DSXchange

In a sequence job there is a command activity stage. You can run commands through it the same as you would from a shell.

Ray, is there any way to do it in version 7.5? Right now I just write all records that don't match the schema to a reject file and then read the reject file as a source to get the records for the second schema. I have two schemas. So I end up with two jobs. I don't like this approach, but I can't th...

You can't have more than one output link in a CFF. (except the reject link)

You need to define the variable in your job as a parameter. Go to parameters and import it from your environment variables. Then you can pass it a value with dsjob.exe.

Did you create the config file using DS Manager? DS Manager allows you to test your config files.

Thanks Ray. Reindexing worked :D I though of doing this but I forgot the command for reindexing.... I wish the DS documentation was better.

I still don't know how it happened. Everybody claims that they did not do anything unusual that could have caused the broken references.

Anyway, thanks again!

I have a strange problem. For some reason all of our database stage types vanished. They only vanished from one project. They are still on the other projects. How can I bring them back? How do you add native stage types to a project? (DB2, ORACLE, SQL Server, etc..) I looked at the DS_STAGYTYPES fil...

Don't need to use a modify stage to change the name of a column. Use the copy stage (or the next stage reading the input). Copy stage gets optimized out of the job when it is compiled so there is no extra overhead. PS: you can use a modify stage to rename columns, but it functions and rules are diff...

how about if you use a copy stage and only select the columns that you need for each stream. If you need to filter them later on then use a filter stage.

Transformer stages are kind of slow and should be avoided in high volume jobs if possible.

Maybe you have case sensitive selected in the dubplicate stage and not in the join stage.

This will do it:

DecimalToString(ColumnName),"fix_zero,suppress_zero")


NOTE: One of the previous posters spelled suppress with one p.

This will do it:

DecimalToString(ColumnName),"fix_zero,suppress_zero")

you can use DSJOB.EXE with the -log option to dump the log and grep it for the entry you are looking for.

-check that the data types are the same ... example varchar is not like char becuase char adds padded characters.

-check if your partitioning is set correctly.

-double check if your lookup file actuallyhas data in it.

In windows the datastage STOP command or kill job command (in Director->Job->Cleanup resources) doesn't seem to do much. It takes just as long to stop the job as it does to let it run to completion. What I do is I use the windows command TASKKILL to kill the OSH.exe processes that are running under ...

I've seen this question posted many times and there were no complete answers. So I'm writing this for the sake of closure: Importing fixed width decimal columns Set these properties in the sequential file stage: in the Format tab: 1)right click 2)select "Format as" 3)select "fixed-wid...