DSXchange

You can't really stop 'reading' at the first record delimiter. What I supposed the suggestion is would be to attempt to pull off the first 'record' in the Derivation after the entire file has been read in. May work... but I don't think that's the right choice of character to look for. Is this a UNI...

Hi All, Is there any option in Folder stage to extract file name and first record of source file instead of all data? Can I make use of Derivation field in output column page? Hi, I would see two solutions here: 1. Read the file name and contents to the transformer and set the derivation to read th...

Hi, Yes you can extract file name and first record from file name too using field function. For file name map key column from folder For first record : Field(Column2,Char(13) : Char(10),1) Thank you, Anupam Where I have to use that Field Function? In transformer? What I'm looking for is to get file...

Hi All,

Is there any option in Folder stage to extract file name and first record of source file instead of all data? Can I make use of Derivation field in output column page?

What is the use of derivation field here, by the way?

Thanks

ray.wurlod wrote:Does the Folder stage have a filter option? ...

WildCard field in Output Properties page does the filter for source file. Can use File* to filter File1, File2....

Hi All,

Is there any limitation of parameter passed to Routines? What is the maximum characters that allowed to pass to routine in Server Job?


Thanks

Thanks ArndW. Re-indicing solves the problem.

Hi All, In my project, some jobs name are showing two/three times under same category after doing deleting and importing modified jobs. Again, say job name abc is appearing three times, I can delete one but two still remains. When I delete others, it says "Job abc does not exist in the project&...

Hi All,

While I'm importing some jobs to Dev environment, the connection is dropped. When I reconnect and import again, I can not import one job, complaining <JOB NAME> already exists but it cannot find in repositoary.

Please advise.

Thanks

Hi Ray, Not only row/sec figure, the elapse time is also taking longer than no inter process row option. Hi ArndW, Just happened addressing to ray on reading his advice. I really appreciage your help. Development server has 1 processor, production has 4, so expected to have better performance in pro...

Hi Ray,

I created a job with four transformers, one having 5~7 lookup. When using inter process row buffer, overall performance is like 50 records/sec. When not using inter process row option, it runs like 250 rows/sec.

Is there any issue with this? Any suggestion?

Thanks,

ray.wurlod wrote:Some are completely undocumented. Some are documented in DataStage manuals. Others are documented in IBM UniVerse manuals ...

Hi Ray,

Can you please tell me which manuals?

Thanks for info

Hi All,
Please adivse where i can get issue DataStage Engine commands statements.

Thanks

I'm facing the same problem, Unix Server, DB2. Could you please explain which level I have to set, is it OS Level or DataStage Server level? Any tip on how to set in OS or DS Server? Hi Pxlearn, i have also faced a similar problem.At last I found that the problem is not with the Datastage. Changing ...

Hi Roy,

Could you please share how you solve this NLS issue?


Thanks