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.
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
...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.