Search results for query: *

I think that select cast('20041101' as date format 'yyyymmdd') would give a better result.

OOOPS,[hammer] I was too fast in my answer. If your value is 0, (FIELD_n (format 'Z(x)')) will return an empty string. Use trim(FIELD_n (format 'Z(I)9')) to be sure to get a '0'. Use (FIELD_n (format '9(x)')) when you want a fixed length completed left with '0'.

Hi, I suppose your field_3..6 are defined as DECIMAL or NUMERIC. You have to FORMAT these values before concatenation. trim((FIELD_n (format 'Z(I)')) will answer your problem in a generic way. If you are sure aboout the length of your field, you can use a simpler (FIELD_n (format 'Z(x)'))...

!!! Be carefull. Don't forget the sign. INTEGER is a signed type, with stores values between -2147483648 and 2147483647 So, if you cast to format '9(10)', the sign could be lost.

Larger than VARBYTES are BLOB columns, next page on your "SQL Reference: Data Types and Literals" manual ;-)

If your Databases are on the same machine, it will be easy to compare the structure of tables (column and indexes) via the DBC tables. Even collected stats can be compared by this way. If your db's are not on the same machine, I think the easiest way to compare structures is to extract tables...

INTEGER is a four bytes signed value. With a simple operation, you can verify that : 2150272280 + 2144695016 = 4294967296 with is equivalent to 2**(8*4). Idem with your other values. To store a value larger than the range of INTEGER, you have to use DECIMAL or FLOAT values. To convert your...

Before using the DROP solution, try to close your already opened fastload session : logon ... ; begin loading ... errorfiles ..., ... ; end loading ; logoff ; In most cases, it's enough to unlock your tables.

The first way I use to unlock a mis-fastloaded table is to close the fastload operation on this table with an empty fasload command. fastload <<-!Eof >> ${LOG_FILE} 2>&1 logon ${DWHTDP}/${DWHUSR},${DWHPWD} ; begin loading ${TBL_BASE}.${TBL_NAME} errorfiles ${TBL_BASE}.${TBL_NAME}_ER1 ...