Search found 258 matches

by samyamkrishna
Mon Jan 03, 2011 4:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Pattern -- Reading sequentially
Replies: 13
Views: 9340

its in the file property something like command
by samyamkrishna
Mon Jan 03, 2011 1:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to add 5 text files in a sequential file....
Replies: 2
Views: 1349

Re: how to add 5 text files in a sequential file....

in the sequential file stage. properties use specific files and give all the filename.
by samyamkrishna
Fri Dec 31, 2010 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using shared containers
Replies: 7
Views: 2953

You do not have to give any metadata. Enable RCP and pass teh columns as parameters to the container on which you are doing calculation.
by samyamkrishna
Fri Dec 31, 2010 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using shared containers
Replies: 7
Views: 2953

Re: using shared containers

You can do it by enabling RCP on the columns. The mandatory colums you can enter the metadata and teh other columns you can pass through by enabling RCP.
by samyamkrishna
Fri Dec 31, 2010 4:13 am
Forum: General
Topic: Execute Command Stage return value
Replies: 6
Views: 14814

In the trigger tab.

Expression type : Custom
Expression : <Execcmdstagename.ReturnValue>=1

Is this what you have given
by samyamkrishna
Thu Dec 30, 2010 6:58 am
Forum: General
Topic: How to find the jobs location in Unix sever
Replies: 12
Views: 5669

Re: How to find the jobs location in Unix sever

Sorry I dont understand your question.
by samyamkrishna
Thu Dec 30, 2010 5:45 am
Forum: General
Topic: How to find the jobs location in Unix sever
Replies: 12
Views: 5669

Re: How to find the jobs location in Unix sever

run

. /opt/IBM/InformationServer/v812/Server/DSEngine/dsenv

and then run the dsjob command.
let me know if it works out or not.
by samyamkrishna
Thu Dec 30, 2010 5:29 am
Forum: General
Topic: How to find the jobs location in Unix sever
Replies: 12
Views: 5669

Re: How to find the jobs location in Unix sever

The command is

dsjob -ljobs projectname

If this does not work try exporting the dsenv before you run teh command.
by samyamkrishna
Thu Dec 30, 2010 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ put time error
Replies: 1
Views: 1071

Re: MQ put time error

Hi ,

The issue is resolved. When we read an xml from MQ with PUT_TIME and PUT_DATE The xml i nput stage bu default takes xpath.

We removed teh xpath expressions Its working fine now.
by samyamkrishna
Thu Dec 30, 2010 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Determining file delimiter
Replies: 4
Views: 3161

Re: hi

did you try opening the file and checking
by samyamkrishna
Thu Dec 30, 2010 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ put time error
Replies: 1
Views: 1071

MQ put time error

Hi, When subscribing the messages from MQ, we have activated the options PUT_TIME and PUT_DATE. Now the MQ we are getting an error XML_CustGnrl,0: Error: Unknown nodetype: Messagequeueputtime pattern = 'dsXMLInput:serialize(SALES/Messagequeueputtime(GMT))'(Unknown URI, 219, 98) Remaining tokens: ( '...
by samyamkrishna
Thu Dec 30, 2010 4:52 am
Forum: General
Topic: How to find the jobs location in Unix sever
Replies: 12
Views: 5669

Re: How to find the jobs location in Unix sever

You want the job list or are you looking for a particular job.
by samyamkrishna
Thu Dec 30, 2010 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best partitioning method
Replies: 5
Views: 9505

use hash partitioning and use the the keys which you are using in join for the partitioning.