DSXchange

No. Because you cannot use a basic transformer then.

Well, instead of the DRS stage, you can use an odbc stage for direct lookup and specify that this link returns multi-row result set.

An enterprise edition will also let you develop server jobs so the engine is still there. That is why it allows you to use a basic transformer in px jobs, provided you are on an smp environment.

A better way would be to do a select from your table and do a lookup on your first sequential file stage based on the key and get the output.

Do you have to use -user option? Try running the following from your datastage server.

where <<ProjectName>> is your project.

You can use these BASIC routines in a basic transformer in a parallel job.

Another good point by gateleys. Modularization has lots of benefits as opposed to its couterpart design.

More number of jobs (modularity) will give you ease of debugging, along with restartability. A single huge job will make debugging a nightmare. Forget about restartability. Weigh your options. You can probably create a single job to extract, transform and load to staging datasets. Two more jobs, one...

Have you defined all lengths and precisions of decimal fields in your job? One of them might be missing. Double check your meta data.

Thats enough information Ken. As always, you rock, and we learn.
Regards,

Welcome Aboard If you know the maximum number of columns your csv file can have, you can create the metadata according to that. For missing columns yo can go to the column's tab and specify the 'Missing Column' option, so that the sequential file stage wont complain. You can set constraints in the t...

Understood. The main point for this design is to ensure both the reference and source keys end up in the same partition. Beautiful.
Is you syncsort cat up on your website for public usage or its client propriety material

O crap. Totally missed that one.

This is not a routine but a complete program. Get rid of the main an change it to your function name. Test it out from command line by having a main function. Make sure it works. Then take out the main and compile the function again. Then call it from within datastage.

You need an End statement after each condition.