Search found 46 matches

Go to advanced search

by Rajee
Mon Mar 24, 2008 9:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data store in data set
Replies: 5
Views: 1246

If you want a dataset with just the keys, use a modify stage after your compare. Either specify DROP and list the columns to drop, or specify KEEP and list the columns to keep. When you say 'read the data from data set', what do you want to do with it? We need more info. Brad. I am comparing two fl...
by Rajee
Mon Mar 24, 2008 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: file comparision
Replies: 3
Views: 923

file comparision

Hi,

Can anyone let me know the effecient way of file comparision through datastage.i need to compare two flat files based on a key column and output the records that are different in the compared files.

Thx,
Rajee
by Rajee
Mon Mar 24, 2008 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data store in data set
Replies: 5
Views: 1246

data store in data set

Hi,

Kindly clarify if there is any way to write only the key column value of the compared files to the first,second columns of the compare stage's output link instead of writing the whole record and also the method to read the data from data set.

Thx,
Rajee
by Rajee
Mon Mar 24, 2008 1:17 am
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

ray.wurlod wrote:Please verify that the name of your job is BIOS_OUTNA_OWNDELT_FILE_GENERATION, the name of your Sequential File stage is TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE, and the name of the input link is ...
I have checked it,all that are perfect.
by Rajee
Sun Mar 23, 2008 11:45 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

Then on what basis are you claiming that it's not being recognized? Look in the "job starting" event in the job log and report the values of job parameters being passed to the job. It may be, of c ... ok.let me explain you clearly. 1.The env variable that i am using is OUTNA_TARGET_DIR an...
by Rajee
Sun Mar 23, 2008 11:12 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

It does work. I just tested it. Here's what I see in the "job starting" event in the job log: Starting Job EnvVarParamTest. $SEASON = Spring [$PROJDEF] It correctly picks u ... Agreed,even when i look into the job log i could see that the value is correctly picked up but in the designer w...
by Rajee
Sun Mar 23, 2008 9:00 pm
Forum: General
Topic: export command
Replies: 6
Views: 1356

Thank alot for all your response.

Thx,
Rajee
by Rajee
Sun Mar 23, 2008 8:57 pm
Forum: General
Topic: export command
Replies: 6
Views: 1356

kumar_s wrote:You can either do it in Individual job wise in the category. ...
by Rajee
Sun Mar 23, 2008 8:56 pm
Forum: General
Topic: export command
Replies: 6
Views: 1356

ArndW wrote:There is, unfortunately, no method to export just a category. ...
Thank you.
by Rajee
Sun Mar 23, 2008 8:54 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

You do not use $PROJDEF in the Administrator. You set a "proper" value in the Administrator. You use the special token $PROJDEF as the default value of an environment variable job parameter. It doe ... Ofcourse I did not ues $PROJDEF in the administrator and i have set a proper value for ...
by Rajee
Sun Mar 23, 2008 8:51 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

deanwalker wrote:Have you set the value of the variable in the Administrator for that project, and restarted the Designer.
Ofcourse I have set value of the variables in administrator fr that project.
by Rajee
Sun Mar 23, 2008 8:50 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

chulett wrote:That and what exact 7.x version are you running? ...
Iam using 7.5.2.
by Rajee
Sun Mar 23, 2008 8:49 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

mikegohl wrote:Where are you trying to use it?
Iam using it in the Datasatge designer.
by Rajee
Sun Mar 23, 2008 8:48 pm
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

mikegohl wrote:Where are you trying to use it?
Iam using it in the Datasatge designer.
by Rajee
Fri Mar 21, 2008 6:20 am
Forum: General
Topic: $PROJDEF
Replies: 18
Views: 5513

$PROJDEF

Hi,

The special string $PROJDEF setting is not recognised by the server and hence not able to view the file through the designer.
Can anyone let me know if there is any setting required in any config file,or the server for the special string setting to be recognised.

Tnx,
Rajee

Go to advanced search