DSXchange

Or you can load it into your own locsl universe table and do whatever you want with user-defined query.

Ray thanks for your reply. This job just extracts from DbaseIII files and writes to a Sequential File with one lookup to hash file in between. But this is done on 21 Dbase files in this one particular job which means that I have 21 ODBC Stages sourcing from Dbase files creating 21 Sequential File St...

Try using

If Len(Trim(Transform_Full_File.FNAME)) = 0 Then @Null Else Transform_Full_File.FNAME

Hello Everbody I have 2 jobs 1.Batch4ShiftLoadDBFtoCSV 2.DbfExt4thShiftMergeCsv The 1st job is a Controller job which just runs the second job in a loop with different parameter value everytime. These jobs have been working fine so far but we just upgraded the ETL server to Server Ver 6.0.1 from 6.0...

Yes I do have NLS enabled and thats exactly what I want to do determine the Locale based on the Job Parameter value. I think I should be able to use your suggestion.

Thanks once again Ray.

How do I set the NLS Locale at runtime I am running DS6 on Sun system.

The easiest way is just to merge the files using cat command in unix and feed it to your existing job

but how do i use Compare with the previous value ?

Are you doing Sorting or Agregation or Link Collector in this job ?

If yes try to stage the data into a temporary file before sending to the above mentioned stage.

I had the same problem with one of the jobs using Link Collector.

What is the default length for a staging variable in a Server Job on DataStage6 I have to pick up the unique values from my source flat file I am using a combination of Sort and RowProcCompareWithPreviousValue() The Data is 380440802865249131 380440802865249149 380440802865249149 and when I pass thi...

Thanks Ken and everybody for the help though I haven't tried it yet but Ken's approach looks more logical. My source is a flat file and targets is Oracle9i but the problem is I dont have DDL privilege on the Oracle DB so for these kind of situations I generally use the UniVerse (haven't used UV befo...

My situation is that I have a COMPANY_CODE field(input) which returns me multiple PLANT_ID (from hash lookup and UVStage) and then I have to create an output of n rows for that particular COMPANY_CODE is there any better way of doing this. eg : Input : CO_CODE = 110 Hash File/UV Lookup Reference: CO...

I am very Sorry Emma for using your forum.

Do I have your permission or should I open a new one for myself as my problem was INDEX related.

Sorry once again

Tried to change from Pre Job to a new job that runs before the job in question as suggested but it still is one row per second.

[V]