DSXchange

I have " OCCURS 2 TIMES" mentioned in the copy book. I really dont understand about the other terms you asked for. What is the difference when I say flatten all arrays?

I have " OCCURS 2 TIMES" mentioned in the copy book. I really dont understand about the other terms you asked for. What is the difference when I say flatten all arrays?

Yes it does when I import the metadata into the stage. What do I choose there. Flatten selective arrays or Flatten all arrays?

Should I try using the flattened pattern option instead of As Is option. This could be a reason right?

Yes I do have many Comp-3 columns.

Thank you for reply. No I did not get any warnign with importing the metadata.

How can I check if the file is data is shorter than the metadata? If it is then I can remove the extra columns from the metadata.

Hi All, I am trying to read a EBCIDIC file using a CFF stage. I get the following error: Complex_Flat_File_0,0: Short read encountered on import; this most likely indicates one of the following possibilities: 1) the import schema you specified is incorrect 2) invalid data (the schema is correct, but...

As per my understanding you will not be able to do it.
You try inserting the records in a sequential file and then read the records.

Thank you
I executed the command but it did not display anything an empty string

How do I check that?

How do I check that?

I have researched the site for Invalid Character conversion also. But could only get to know that the character set is not in sync with that of Oracle.

What are the environment variables APT_INPUT_CHARSET or APT_OUTPUT_CHARSET used. Can we use these here.

Hi All, I have issue where in I am using a ODBC Enterprise stage and trying to read data from the table. We have setup the connection and trying to access the Oracle table for the first time in the DataStage. The job runs fine but I get this following error message. Also when I view the data from th...

Your input string looks like it contains timestamp.
If yes, convert it to timestamp and then to date

Hi
I have a query..
I have a .osh file.. I want to locate the DS job for this .osh file. How do I do this.

Thank you in advance