String concatenation within INFORMIX-SQL "Perform" screens.

Posted by Frank Developer on Stack Overflow See other posts from Stack Overflow or by Frank Developer
Published on 2010-03-07T20:06:41Z Indexed on 2010/03/08 6:21 UTC
Read the original article Hit count: 622

Filed under:

informix

How can I concatenate two char columns within a perform screen?

example:

table sample

col1 char(1), col2 char(1)

. .

after editadd of sample

let label_3 = sample.col1 + sample.col2

.. this didn't work, I even tried using subscripts for the 2 cols but no dice!

Related posts about informix

How to improve Java perfomance on Informix for Windows

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with performance of Java UDR functions on Informix on Windows. On this server I already have some functions in C and SPL. I chose one function to write it in those 3 languages and I measured performance of this function on test table. Function calculates some kind of checksum so it… >>> More
Informix "Database locale information mismatch"

as seen on Server Fault - Search for 'Server Fault'
I have informix 11.5 running in my Win-2003 box and few databases running in it. System databases have locale en_us.819 My custom databases have locale en_us.57372 (UTF8). There is also application deployed to JBoss 4.0.2 which has few datasources configured for those custom databases. <local-tx-datasource> <jndi-name>InformixDS</jndi-name> <connection-url>jdbc:informix-sqli://@database… >>> More
Problem with Informix JDBC, MONEY and decimal separator in string literals

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with JDBC application that uses MONEY data type. When I insert into MONEY column: insert into _money_test (amt) values ('123.45') I got exception: Character to numeric conversion error The same SQL works from native Windows application using ODBC driver. I live in Poland and have… >>> More
Users Login Info in INFORMIX-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id… >>> More
String concatenation within INFORMIX-SQL "Perform" screens.

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! >>> More

Developer IT

String concatenation within INFORMIX-SQL "Perform" screens. - Developer IT

String concatenation within INFORMIX-SQL "Perform" screens.

informix

Related posts about informix

How to improve Java perfomance on Informix for Windows

Informix "Database locale information mismatch"

Problem with Informix JDBC, MONEY and decimal separator in string literals

Users Login Info in INFORMIX-SQL

String concatenation within INFORMIX-SQL "Perform" screens.

Categories cloud