DSXchange

You dont need to have a seperate job for each record type. You can do that in the CFF stage with one output link for each record type. In CFF stage, on the Records tab, unselect the single record option, add 10 records to it. Import the 10 copybooks you need, one in each of them. Then if you have a ...

Did you add all of these columns as key? I dont think its possible. You can have only one column

I believe you have 'REP_TYPE' as the repitation (Key) in your XMLoutput stage. You should change it to 'S_NO' from what I see in your sample data.

XMLOutput stage converts tabular data to XML

These jobs run at the same time? Have you tried running that particular job alone? Have you checked the uniqueness of the 'Invocation IDs'?

I guess "Not in a runnable state" error may occur if you are trying to run the job with same Invocation ID more than once at the same time.

Craig,

Isn't that easy to retrieve a password encrypted in ENV variables? When I dont know the password and if it is available in ENV variables, I assign it to a file name in the seq file stage and try to view it. I will have the password in the returned error message.

In your Designer go to - Tools >> Options >> Appearance >> General >> Job preview tooltip and select "Do not popup" in the drop down.

The column which you are checking for NULL is from any lookup or join? If so, have you defined $APT_STRING_PADCHAR?

There is a function Dtx() in server jobs but I'm not sure if that is available in Parallel. Maybe you can use a BASIC transformer and call this function.

I am still looking for a solution for this

You can also have two identical output stages in your job, pass your counter value as a parameter to determine the start of the loop and have one stage create (Overwrite) the file and the other stage append to the file for subsequent runs by having proper constrains.

You can write it to a sequential file as is and create another job to treate it as XML input file and read the data.

If it is Variable block file in binary format, each and every record will have the record length in the begining. You can read in that and route your records... We have jobs like that in DS 390 but it should work the same way in parallel

I never tried it before but cant you use a BASIC transformer and set the status?

Set the stage variable as user status of the job.