Search found 5 matches

by Mercury
Tue Jun 29, 2010 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how do we know when a job was compiled
Replies: 5
Views: 2317

udayk_2007 wrote:you can usually see this information in DataStage Director
Hmmm..true
But there's a limit to the number of messages retained in the log, so I don't find this info in the log..

Also, is there a way to know the date/time when a job was last modified?

Thanks
by Mercury
Tue Jun 29, 2010 12:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how do we know when a job was compiled
Replies: 5
Views: 2317

how do we know when a job was compiled

Hi, Is there a way to find the date/time of compilation of a job?

Thanks
by Mercury
Thu Apr 15, 2010 3:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot in a single column
Replies: 4
Views: 1556

Re: Pivot in a single column

sv: for stageVariable

ignore the first 5 lines
svLineNum to store lineNumber
svEntireLine=entire_line
col_num=Mod(svLineNum,5)

svName: if (col_num=1) then svEntireLine else svName
svAge: if (col_num=2) then svEntireLine else svAge
...
svENO: if (col_num=0) ...

constraint: (col_num=0)
by Mercury
Fri Oct 09, 2009 10:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage trouble with DB2 dbm cfg DATA_ENCRYPT
Replies: 3
Views: 2500

So... you made this change in your DB2 XMETA database and now can't connect to DataStage at all? Or you can't connect to that external database from DataStage? ... That's right, I am not able to connect to DataStage at all. When I try to connect to web-console or start datastage-designer, I get an ...
by Mercury
Fri Oct 09, 2009 12:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage trouble with DB2 dbm cfg DATA_ENCRYPT
Replies: 3
Views: 2500

DataStage trouble with DB2 dbm cfg DATA_ENCRYPT

I am using DB2 v9. As per a security policy of my company, I am required to make a change in DB2 dbm cfg with AUTHENTICATION=DATA_ENCRYPT. Now, I am not able to connect to DataStage. Earlier I had the setting AUTHENTICATION=SERVER and it all worked fine. Has anybody faced this issue? How can I make ...