DSXchange

I got it, I was issuing the right commands in wrong place ie command prompt at the directory where these executables reside.
When I tried executing the same commands in DS Admin window, I got the results.

Thanks for your support and help..

//Papan

[quote="ArndW"]Papan, when you see the prompt that states the account is not setup for DataStage do not say "yes" - it will add the minimum number of hashed files to that UNIX directory to make a valid UV account but it does not create a valid project directory. The question is h...

Hi DSServer is configured on Win2003. I can export whole project thru command line using dscmdexport.exe, While importing I would like to import selective jobs/components from dsx. I couldnot selectively import by using dsimport and dscmdimport.exe. I issued dssh in ds ..\engine\bin. Prompted me a m...

Dude You can apply the same logic in one job, from the rejected file try placing a transform stage and try to place instance of the same target table and link them. I hope in this way you can accomplish the same in one job. [quote="nair"]Hello Everybody, I want know about the lookup stage....

Hi Pals, The reason why DS is writing rectype 1 and 2, 10 and 5 times respectively is the CFD for RecType1 contains a statement like aaaa redefines bbbb occurs 10 times, similarly for type2 xxx redefines yyy occurs 5 times. DS is doing what its supposed to do. DS can handle redefines and occurs sepa...

Using ProfileStage is it possible to perform column level analysis against Multiformat Flat File of variable block and having atleast 5 different layouts.

Any help on this front will be highly appreciated.

Thanks,

[quote="Mike"]Papan, What is your setting for "Lookup technique"? What is your "Lookup condition"? What is your setting for "Action if lookup condition fails"? I suspect that you have "skip row" for a failed lookup. I think the records read count for...

[quote="Mike"]What do you mean by "unable to write it back to output"? Mike[/quote] The Job Details and the spool report is as follows: Typically I've used 1 CFF stage (primary source), 1 FixedWidthFlatfile (lookup), Lookup Stage, and FixedWidth Flatfile (output). There exists 6 ...

[quote="Mike"]Job parameters in a mainframe job are very different than in a server job. What use do you have in mind for your application? A mainframe job reads its parameters from a single record in a simple flat file during initialization. Mike[/quote] The usage of the application is as...

I'm a rookie, I'm trying to read a flat file and looking up another flat file, the object is send only those records whose fname exists in lookup file. The job is able to read records from both primary source and lkp source, but unable to write it back to output. Lookup condition: DSLink4.EMP_FNAME=...

[quote="ray.wurlod"]Can you be more specific? There is no mention of a parameter file in the [i]Mainframe Job Developer's Guide[/i] - in my experience you simply use the same Parameters grid in the job properties window as you do with other job types. In particular refer to pages A-15 and ...

Hi
I'm working with DataStage7.5.1 for Enterprise Edition for MVS.
Can any one send me how a parameter file looks in MainFrame and its usage within DataStage Jobs, Ascential Best Practices.

Appreciated..

I've selected flatten all arrays while loading the metadata and also I right clicked the transform stage, and selected propagate columns from source link to target link. But still the problem prevails as is. Any help in this regard will be highly appreciated. //thanks [quote="Mike"]Your re...

Hi Using Datastage for XE390, I 've created a job which reads a VSAM-KSDS dataset, having 4 record types (1, 2, 4 and 5), I want to create a 4 separate files (one for each record type). After successfully compiling the correponding cobol code and JCLs, executed the job in Mainframe. But the results ...