DSXchange

Hi guys,
The problem has been resolved.
It was padding with space issue itself. Dont know why ltrim and rtrim didnt work, but when i did 'REPLACE(Some_Field, ' ', '')' it gave me proper distinct records.
Thanks a lot to all!

Hi,
The value for '000051'
came as '303030303531000000000000000000' and '303030303531202020202020202020'

Seems the second is padded with space. Thanks. But then why am i not getting the correct result when i am doing a ltrim and rtrim?

Thanks, but just wanted to know why this happened? Is it because the column length is character 15 and my column value is just 6? Actually, i populate this table through Datastage. I am doign a substring in my transformer and take this column value. I run this Job every tuesday. It never happened ti...

How can i check for junk char values?

Hi, Yes, it is a char 15 column. I did a ltrim as well as rtrim on that column. Also, i checked the length of it.. Basically i did a "select length(ltrim(rtrim(<column_name>))) from table where <column_name> like '%000051%'" Surprisingly it gave me two values 15 and 6. Now the value is 6 s...

Hi i am just doing a
select distinct <column_name> from <Table> in DB2.

I am getting few column names more than once.

Hi,
I did a distinct on a single table on User id. I am still getting duplicate user_ids. Not sure why. (I am selecting only User id )
Even when i trim the spaces off and do a distinct, it is giving me duplicate rows.

Thanks everyone. The problem is solved now.

Hi,
i didnt understand= 'Specifically you do not include the name of the key column in your design.'

Am i not supposed to add my key column (The one i am doing NEXTVAL with ) in the columns property of my DB2 stage?

Thanks i did that. I changed the property to 'User defined Sql'. However i had other columns also, so i changed my target syntax as: INSERT INTO schema name .Table name ( Key field,col1,col2 ) VALUES ( NEXTVAL FOR schema name .Sequence name,?,? ) My Job is aborting saying below: " Fatal Error: ...

Hi,
I have generated a Sequence in DB2. How can i import or use it in Datastage? I want to use it as a key generator in my Job.

Thanks mike. Will check that!

Hi, My Job uses 2 sources, then a change capture stage then inserting the changed records in my DB2 stage. I am getting below mwnetioned warning: " Assignment of a NULL value to a NOT NULL column "TBSPACEID=4, TABLEID=114, COLNO=0" is not allowed. SQLSTATE=23502 " I am getting th...

Hi, Thanks for your reply. I am not a Premiuim account holder so i could not see half of your 2nd message. I did change the format to fixed width. By display width do you mean the Field width that you get after double clicking each column? I changed that also. But got the below mentioned error: &quo...

Hi, I have a file. It has lot of columns. However, some columns are together without any space in between them and some have space. For eg: 0000492007-02-28 1020001 1 5066 0.4 000049 is first column 2007-02-28 is second 1020001 is third. What property do i need to set in my sequential stage to get t...