DSXchange

I am getting the following warning messages and I cannot view the data. The error is not clearly stating the reason for failure. ##W IIS-DSEE-TOSH-00049 19:37:07(005) <main_program> Parameter specified but not used in flow: DSProjectMapName ##I IIS-DSEE-TFSC-00001 19:37:07(011) <main_program> APT co...

Thank you. But, how do we get the column name which failed validation.

I was thinking more on the lines of using 'IsValidDate' and 'IsValid' for numbers. I think that should work right.

I need to capture certain data in error table which has the following feilds: - SrcFileName - ColumnName - ColumnValue The basic rules for identifying a bad value is like - checking if the column is not a valid number or if its not a valid date. For eg., the Src looks like this: EMP_ID B_DT Age Sala...

How do we capture the following into a target file

- Sourcetable or SrcFilename
- ColumnName (selected)

Is there any other way of doing this otherthan hardcoding them in transformer? Thank you,

Kumar

I am trying to load data from one CSV file to another CSV file. Its a simple job. I created the target file using the touch command so a zero byte fiel exists in the target folder. Validation is OK. When I run the job, it says the following for the target file: Target,0: Unable to open /opt/IBM/Info...

I am loading an Oracle table with daat from a SEQ file. THe table need a Sysdate and Job_name. Is it possible to derive these without using transformer stage? Just curious?

Kumar

Thank you everyone.

I have a schema file like this for a fixed width file. This is just a sample. ODW_TYP 1 2 BANK_NBR 3 5 ACCT_NBR 6 17 AAS_ACCT_TYP 18 23 AAS_IND 24 24 The schema file has more than 300 columns. Is there any way that I can import this metadata directly into datastage without manually entering all the ...

I understand that that ETLStats is not free. There is a trial version. Not sure if my company would be willing to buy it. We were thinking that we will do it as a part of the each load. Not sure if I can achieve this using datastage PX. When we were brainstorming, some one suggested that I use some ...

Hello,

I need to copy the following stats of each ETL process into a DB table:
THanks,

Kumar

Sorry, for the late reply. I did not do any special thing when I imported the Cobol FD. It did not throw any error when it imported the FD. Your 2nd question makes me think that if I am really using the right metadata file. Just a silly Q - is there anyway that I can confirm by looking at the data p...

After importing the defns, I tried to convert an mainframe file to seq file, I am getting the following errors: Complex_Flat_File_9,0: Import consumed only 285bytes of the record's 574 bytes (no further warnings will be generated from this partition) Complex_Flat_File_9,0: Import warning at record 0...

Ray - THank you for your reply. I have few other Q's also. - I did finally called the src prople and got the defn file and imported using Import Cobol defn. That went fine. But when I drop the drop the CFF stage and import metadata and then view the data, I see all weird characters like ???, 000 etc...

I have few source files which are EBCDIC files. I need to load them into an Oracle DB. This is the first time that I am dealing with these files. Can I use datastage to directly read the data file and define the columns when it reads it or I need a defenition file for it like a copy book. I don thin...