DSXchange

The thing you need to invoke from the command line is a job sequence that reads the parameter file then uses the results from that to provide parameter values to job activities that are downstream in the job sequence.

Pre-process the file by reading it as a single column (or maybe two, if the record type is in the first position), using a Transformer stage to split the stream according to record type.
There are various techniques for preprocessing EBCDIC to ASCII.

Given that you're picking up the parameter setting arguments with $* are you correctly specifying them as "-param name=value" when invoking your script? Your shift command will move the parameter list to the left. So you lose the parameter file first. Probably not what you wanted. (Add echo statemen...

You set up derivation expressions for the three columns. They will be based on the If..Then..Else logic you have described. For example STS is derived as something like If InLink.STS = "N" Then If InLink.UserID = "Pesft" Then "Y" Else If InLink.UserID = "etlsot&quo...

The deadlock daemon does not "block" anything. It wakes periodically (this is its "time" setting) to check whether there are any deadlocks in the Repository. Note that it does NOT check for deadlocks in your database servers. A secondary task performed by the deadlock daemon is to clean up any locks...

Welcome aboard. :D Your question suggests some unfamiliarity with job parameters. If you define a job parameter, then you can use a reference to that job parameter (surrounded by "#" characters) in your sequential file stage. However, this would only let you process a single file. To process multipl...

The clock starts running right away, but rows may not. Before any rows can be processed, all files need to be opened, connections must be made to all database servers, SQL must be prepared by those servers, and any before-job (and maybe before-stage) subroutine and/or job control code executed. The ...

@INROWNUM gives the true row number of the input stream. If you split this (for example with a Link Partitioner) then the only way you can guarantee contiguous numbers at the end is to make sure your collection algorithm (in a Link Collector) preserves sorting by row number. Alternately you could in...

Create a routine that passes its argument unchanged but also loads it into the user status area.

Pass your value through this function during its derivation.

The previous record has already been processed when you are processing the current record, and therefore can not be edited other than in a second pass through the data or some form of intermediate storage that can be updated (for example a UV stage).

Did the 5000 rows actually make it into the target table? Or did the entire transaction roll back? Do you use a staging area of any kind between your ETL and your actual load process?

We don't do "urgent". This is an all volunteer site. No-one is paid for the time they spend posting here. No-one. If you want urgent answers, buy premium support from your support provider. Those who do provide examples of the kind you seek usually do so within the context of their own training pack...

OpenSeq will take its Else clause if the file being opened does not exist. You are unconditionally aborting in this case. You probably do not want to do this; check the Status() function to determine whether the sequential file is, in fact, opened for writing in the Else clause. Find a generic seque...

Make sure both groups of users have their umask set to 002.
Run DS.REINDEX ALL on the project.