DSXchange

Set this Property on Format Tab of the Sequential File Stage.

Change the directory name with Double Quotes

"C:/Documents and Settings/User1/Desktop/DSX/A_custinteraction"

Below is the Query you are looking for.

Yes you can. Execute the following command. for i in `dsjob -ljobs ProjectName`;do `dsjob -linvocations ProjectName $i`;done | grep "1" Or for i in `dsjob -ljobs ProjectName`;do `dsjob -linvocations ProjectName $i | grep "1"`;done I haven't tested. modify as per your requirement.

Read entire row as single column.
Have a transformer between Sequential File and Database Stage.
Check the number of fields in Transformer Stage Variable. If it is less then what you are expecting then reject by using constraint.

Does Ray mean. We can have unlimited columns in all stages.
But the limitation is only on OS and Database Side.

Anyone have the document on Column limitations in Datastge.
We have a requirement where we need to load thousands of columns.

Or

Double check the mapping.
Do you have any Unique Indexes or Triggers on Table.

Thanks Ray, I have renamed the Columns in Table and recreated.

Ok, when we go for Schema File with RCP we cannot use derivations.
Just wanted to know is there any other method to load using Column names as numbers. Handling $ and # characters we can do.

one of the target database has column names as number.
will the datastage support the Column names as number.
i have checked already but need to load the data from file to Database using schema file.

First list the jobs using dsjob -ljobs projectname and write into file.

And then pass the jobnames using for loop

dsjob -jobstatus projectname jobname

Grep the status which ever you are looking for and reset it by using

dsjob -run -mode reset projectname jobname.

If the Output is single row.Use Pivot Stage to split single Row into Multiple rows

Yes it is.

Use Switch Stage or Filter Stage or Transformer Stage