DSXchange

I am facing a issue while using the surrogate key in the transformer, i am reading the max value from a column of a table and updating the surrogate key in the first job which runs in the sequential mode. the settings for the surrogate key generator stage in the job 1 are key source updated action =...

Sorry I think I was not clear about my question. I was thinking that can we give 3rd column (Position 11) as the Record Identification or it should always be the First column to identify Header and Detail. I have given Record Id as Header_Id1='H' for the Header and Detail_Id1= 'D' for the detail. (F...

When I was checking I got a doubt that can we use any column as the Record Id or should we use only the first column as Record Id in the CFF stage when we have multiple record definitions? can anyone clarify this and help me resolve? I have checked in the documentation but it was mentioned that all ...

I am getting the Header Record with all Invalid() here is the sample data I am getting when I view Data for the Header

**Invalid(012c02) like this with some code inside Invalid() in all the columns and getting so many rows with that same invalid codes.

Thanks.

Thank you all for the information. Not sure if the Fix pack is causing the problem because we use Fix Pack3 and when I read header and Detail separately (using two CFF stages) I am able to read the data properly. so I am thinking it might not be the problem with the Environment. When I try reading H...

just used the below conversion String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6 %aa')

I have String as Input and have to load it to a TimeStamp(6) in Oracle. My String is like this:3/31/2011 4:05:23.500000 AM When I Do the following type conversion String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6') The value 3/31/2011 4:05:23.500000 PM is getting loaded into the database. It should...

Thanks for the information Franklin. Yes, Mainframe team is sending this file from MainFrame to Unix using NDM. and I have been told that XLATE=NO will transfer the data without conversion from EBCDIC to ASCII so data will be transferred in EBCDIC format. I will check on the CFF stage settings of th...

Thanks Franklin for the information. MainFrame team has transferred the files in BINARY format with XLATE=NO parameter, I was able to read the file but when I try to read Header and Detail in one CFF stage I am getting wrong data in the Header record but Detail records are being read properly. When ...

Thanks Chulett and Franklin. I have tried with "Allow All zeroes" to yes after going through few posts in the forum but it didnt work. When I have removed the default value it was giving me the error saying that "Field has Import error and no default value" so I tried with defaul...

Hi Chulett, It is PIC 9(11) COMP-3.

Thanks.

Hi, I am getting all 0's (though that column has proper values) while trying to read Packed decimals using Complex Flat File stage in Datastage version 8.5.Below are my stage settings. - Data Format: Binary - Character set: EBCDIC (Tried with ASCII as well) - I have given 0 as the default value for ...

Thankyou every one, issue was resolved

Sorry my bad i had mailed to editor@dsxchange.net only. I spelled wrongly in the above post.

Here is the expired date that i am seeing on the home screen Expired on : 2012-12-19.
I had sent an mail to editor@dsxchange.com yesterday waiting for his reply.