DSXchange

Yes, the sequence number of each "key" will be similar to the sequence number in, i.e. Oracle. The structure of the hash file contains: Key Name, Sequence value. For example, if customer number is sequentially assigned, there may be a "key" Name: Cust_Num with an initial value of...

Calvin, How about cloning this routine: KeyMgtGetNextValueConcurrent You may find this routine under sdk/KeyMgt. This is to facilitate "surrogate" key or sequence number in concurrent environment processing. It is using a hash file to track sequence number by "key" name and allow...

One quickie attempt is to check whether you have binary mode on before get/put file, i.e. type I [^]

cwong

Thanks for correcting the use of function ... the time I typed in my reply here, I just finished coding the transalte func in a SQL stmt to DB2 and got mixed up. Yes, I am not a UV guru and have never use the multi-valued column capability of UniVerse tables. Your suggestion would be complicated to ...

I would suggest 2 options: Option #1: - bring in all needed columns from database table via the SELECT stmt - use a transformer stage to concat all columns together with the @FM in between each - translate delimiter in delimited list into @FM (field mark) for example: col1:@FM:col2:@FM:translate(col...

Ray, Use a sequencial file stage in front where the field delimiter will be specify accordingly; in this case will be the "," then inside the pivot stage, will list all the columns. Coming out from the pivot stage will be one column at a time. Use a transformer stage to check if the incomi...

Another suggestion is to use the Pivot stage.
You may assume up to more than 6 columns just in case it will expand in the future.
Then for each column coming out, check if the column is not null then create an output record.

Endy, Folder Stage is meant to support multiple files to/from XML Reader and Writer. For text file, if you have multiple text files to send into a sequential stage, you may use an OS command to combine them into one big file and then use the big file in the seq stage, i.e. cat /inDir/infiles* > /tmp...

The KeyMgtGetNextValue reads in the next value from a hash file named: SDKSequences under the project directory. The SDKSequences has 2 columns: Key_Name and Next_value Key_Name is the key of this hash file. You can have a separate DataStage job to do the resetting or synchronization of the specific...

Thanks chinek. Along with your suggestion, I will try with a job or script to "edit" the export file. FYI, we use a GetParm routine to read in the values from a parameter file and assign to the parameter in the batch control job. The intent is to clean out or empty out the default values a...

Hi all, Have you tried removing the default values in datastage job with a batch job ? This is considered as a safe-guard process after the jobs got migrated from development into production. Just in case and ideally to remove all default values that had entered for the parameters with a batch job (...