DSXchange

Create a sequence job. Add a 'Job Activity' stage. In the properties of the stage select the job name and then in the 'Execution Action' drop down box select 'Reset if required, then run'.

So as I stated before just output the desired results for each file with a Constraint in a transformer stage. 3 output links (1 for each file) and based on field1 the row goes to the appropriate file. A second set of transformers for each file splits the pipe-delimited fields for that file. Is that ...

cani call the second job after completion of each job 32 times

Yes you can but it will look quite messy. I would create a Job Control routine to kick off the first job and then create a loop for the second job that executes 32 times. It is a neater solution.

I would put your table into a hashed file and then use one hashed file as the Input to a Transformer stage and the other hashed file as a look up. You won't need the Merge stage. Make sure the keys that need to match are in the exact same format.

In reply to Phil Hibbs post: I asked this on the course, and was rather astonished that the tutor didn't think it was possible to process unknown file names. It isn't unusual to have to process files that are named with some kind of incrementing sequence, maybe with a date and time included in the n...

What you need is a control file for each file you are looking for. Once a file is FTPed (file1.csv) another control file is FTPed (file1.ctl) to indicate the transfer has completed. In the control file you could even have a row count to check if the correct number of records have been FTPed across.

Not sure if this is the way you'd like to do it but if you're looking for a job you can't find then open Director and in the 'View' menu at the top click 'Show Categories' to remove the tick. This will show you a list of all jobs and which category they belong to. Be warned! It can take a while to r...

I haven't come across a 'final delimiter' in DS Server, but from what I understand you are trying to do you don't need it. If your first field contains 'filename' then you can output the desired results for each file with a Constraint in a transformer stage. A second set of transformers for each dif...

Please post the 'Generated SQL' that is being generated. LEFT (DSLink38.CONVER_DTTM_INIT, 19) = Field (DSLink2d.CONVER_DTTM, ".", 1) I think you should do these comparisons in the join, but if that's giving you trouble I would make the constraint something like this: IConv(DSLink38.CONVER_...

Which database are you using? What is the exact SQL you are using to perform the join? Are you casting the date fields correctly?
Ie. for Oracle you might need:

If your deletion criterea is pre-defined and will not change then just use a parameter driven custom SQL statement as Craig suggests. That's the way I would do it.

In regrads to your first question you should try using something like this for the date part of the timestamp: IConv(InputColumn[1,10],"D-YMD[4,2,2]") And perhaps something like this for the time part: IConv(InputColumn[12,8],"MTS") To answer your second question: Of course you c...

read below

First re-install the DB2 client on the server. Then re-install Datastage on the server. This will set the dsenv file and any other variables needed. Chances are that you can fix it by modifying all the environment variables and DS files, I suppose it depends if you are limited with time. Re-installi...

If you get the job number of your job (nnn) from the DS_JOBS table, then the log for that job is a table called RT_LOGnnn. You can either pipe the results from the OS using the command line interface dsjob with its "-log" options. OR You can create a job that uses a Universe stage with a r...