DSXchange

this is the view when I see in view of DB2 stage for one field but when I view the same field in the table I can view it in proper way like..9999/12/31. but there is an other field which is null(date null) when I view that field in the table I cannot view the proper date also...all the null fields l...

my target stage is DB2 UDB....where can I find the format function in DB2 stage?

please..let me know....

for the null values in the field I gave date like 9999/12/31

now when I see in the table externally it seems to be working well in both the fields.

but when I view the records in the DB2 stage (target)

I see all the records appear like... 233673524 (9999/12/31)

any environment variable required?

sorry If I said its a time stamp, but its not a time stamp its a date.

used the function works well for one column which is not null but for another column which is null the format is changed to date but in the table the records appear like
1/1/4713 for that particular field,which is also date.

yes,changed the null values to '9999/12/31' and after this I need to convert the data type from string to date.

Will this format be according to the DB format or the regular format.

I mean mm/dd/yyyy or yyyy/mm/dd.

AS the target is not null I changed the incoming rows from null to ' ' .
will that satisfy the condition?

If so do I need to change the function used to convert the datatype from string to date

I removed the null values in one of the fields by using If IsNull() then ' ' else after that when I tried to change the format from varchar date I got the below error. and the function I used for that is stringtodate this is the exact error. DB2_UDB_API_115,0: Invalid date value in getInputFieldAsDa...

actually the field should be changed to not null and also the format from string to date....

the table is not accepting the values after the format change.
it says the date format is wrong

used the string to date function.

please help with any changes required in the function or the format

gave two spaces but same warning.

Is there any steps to be followed or nothing like that,I mean to say

first get rid of quotes and then IsNull and then datatype...

The sample date is "2009/04/29" which is read as varchar so I removed the double quotes by using field(dslink102.date1,'"',2) and the column is not null so removed nulls Is IsNull(dslink102.date1) then ' ' else dslink102.date1 with the same data type varchar. at last to change the dat...

I see number of warnings of the below kind when I use target as a table.


DB2_UDB_API_115,0: Invalid date value in getInputFieldAsDate() for field '3' of input dataset '0'.

tried to change the datatype varchar() to date for two fields and one is null and the other one not null. used the function string to date(dslink102.date1,"%yyyy/%mm/%dd") but the data is not loaded in the table. also tried to use sequential file as target but no use. Do I need to change t...

Thanks,

So is it something I need to discuss with my DB admin?

Thanks for the information. Used the environment variable and got rid of these special boxes. Is there any other environment variable to load these chars like trademark and registered like ™ and ® ? The file from which I am reading these characters have these special characters but they can...

Actually I see that when I change the datatype from char to varchar I can get rid of these square boxes. Is there any other way to get rid of these special characters other than changing the datatype. another issue which arises when the data is loaded is the special characters like registered R and ...