DSXchange

tried the same way,assigned a value which says"no-name" but behaves the same way. the flow is remove duplicates stage------>transformer------->table does this change anything in the above ideas. around 400 records come into removeduplicates stage as the duplicates are removed now the outpu...

tried the last shot also,but no solution.

will let you know if I find the solution by tomorrow.

thanks a lot for your input and effort nitkuar

Tried that also but did not help....


thanks,

[IBM][CLI Driver][DB2/SUN64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=5, COLNO=5" is not allowed. SQLSTATE=23502

the above message is the warning I get with out any errors when using only IsNull.



Thanks,

got the same compilation error earlier..

The difference I observe between the two kinds is when I use trim i get this compilation error with out trim I mean only the IsNull no errors but the data will not be loaded as the column is not null and the values are null.

sure

this is the column derivation used in the transformer

If IsNull(Trim(DSlink44.user_name)) then ' ' Else DSLink44.user_name


Thanks,

Yes value in $APT_PAD_CHAR variable is 0x20


Thanks,

craig, The target is not oracle thats a db2,so do I need to use the environment variable. nitkuar, used the code and used padchar also set to 0X20. now I get a compilation error in the transformer and got the msg ##I IIS-DSEE-TOSH-00002 11:54:01(001) <main_program> orchgeneral: loaded ##I IIS-DSEE-T...

Datatype and nullability for the transformer and target stage is
Thanks

I used something like

If IsNull(DSLink44.user_name) then ' ' Else DSLink44.user_name

in the derivation of column in transformer.


but did not work

please let me know if any changes are required.

Hello,

I was trying to load some records in the table but none of the records are inserted because one of the record has null value and the column has not null property.

please suggest a function to use in the transformer which changes the null records to some value.

thanks for the information. designed a sample job when a source which has all the addresses and used CASS stage to a target sequential file also used the reference database from opt/IBM/cass path. I got an error which says "QualityStage Compressed USPS data files are older than 105 days" &...

Thanks, Actually when an address is entered as a request the address should be corrected and then standardized. once it is standardized the address splits into some forms of addresses. there is no need match against the database in this service,only thing is correct the address and standardize and s...

sure I will look at eostic's post.

what I meant was the response for the service is not onlyto correct the address but also standardize it. so I would use two stages CASS and standardize.

If I set the parameter set it would refresh by itself. Is this right?


Thanks

Thanks, OK, I need CASS stage to correct the provided address and then a standardize the address which is corrected because the response form the service has to be all the standardized addresses from the corrected address. When CASS data expires every 105 days does it automatically load the new data...