Search found 63 matches

by MAT
Mon Apr 21, 2003 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environement variable in PX transform
Replies: 5
Views: 1220

Hi, I can use a job parameter without difficulty. I think the problem must come from the conversion string to decimal. the data I am using is numeric and a env variable being a string, I need to convert it to decimal. I use the function StringToDecimal(%string%,[%rtype%]). I put my string in but I a...
by MAT
Thu Apr 17, 2003 1:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environement variable in PX transform
Replies: 5
Views: 1220

Environement variable in PX transform

Hi,

I would like to use an environment variable in a transformer stage within a PX job. The function GetEnvironment should handle that operation but it does not work on my system. Has anybody tried something similar?

Thanks

MAT
by MAT
Thu Apr 17, 2003 1:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can i do "Clear Status File" in my jobcontroll
Replies: 6
Views: 1143

Hi, If you are designing your job control with a job sequencer, you can use the option: Reset if required, then run under execution action in your job activities. Otherwise, using a routine, you can call a jobrun with a reset option: ErrCode = DSRunJob("JobHandle", DSJ.RUNRESET ) Your job ...
by MAT
Thu Apr 17, 2003 1:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Viewing COBOL format props in Seq File Stage
Replies: 4
Views: 1116

Hi, I read COBOL files from Server and PX. Depending on where the jobs is built, I have access to the corresponding tab (Server under Server and Parallel under PX). My guess is you can access COBOL tab from Mainframe jobs but I don't have any way to verify it since we do not make mainframe jobs. You...
by MAT
Tue Apr 15, 2003 10:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage export from command line
Replies: 15
Views: 10980

Craig,

1. I am stupid!
2. You're brilliant!

Thanks a lot

MAT
by MAT
Tue Apr 15, 2003 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage export from command line
Replies: 15
Views: 10980

I am interested in making exports from a prompt too. I found the command but I can't make it work. The usage is: usage: dscmdexport [/H][/U][/P][/O] project filepath [/V] /H Host name. /U User name. /P Password. /O Omit flag. project Specifies the project name. filepath Specifies the export file nam...
by MAT
Fri Apr 11, 2003 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I customize the Log
Replies: 4
Views: 648

Aryan,

I'll be glad to send you what I did. Send me an email through the forum with your mail so I can send it to you.

MAT
by MAT
Wed Apr 09, 2003 9:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I customize the Log
Replies: 4
Views: 648

Hi, I do not know of any way to see the logs for all jobs controlled by another one in Director. However, I needed to do something similar in my project and the best way I found was to do this using a routine. Here are the steps: 1. Get the log from your controlling job ( use DSGetLogSummary() ) 2. ...
by MAT
Tue Apr 08, 2003 11:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX Data Sets History
Replies: 6
Views: 1357

Thanks a lot BP,
My env var were not set properly. It works now

MAT
by MAT
Tue Apr 08, 2003 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX Data Sets History
Replies: 6
Views: 1357

My goal is to write a routine that will do the copying for me. You think it's possible? How can I check if my librairies are set up correctly? I can see the env var but I don't know where the PX components are found. It is probably under the PXEngine directory but then again, I also have a PXEngine....
by MAT
Mon Apr 07, 2003 1:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX Data Sets History
Replies: 6
Views: 1357

Thanks BP,

Being a newbie with PX, I do not know how to build OSH job, is there a document explaining how to do it somewhere?

Regards

MAT
by MAT
Mon Apr 07, 2003 11:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX Data Sets History
Replies: 6
Views: 1357

PX Data Sets History

Hi all, I have a PX question. Is it possible to save a copy of a Data Set under a different name for historical purposes? I would like to be able for example to rename a Data Set named example.ds to example20030407.ds. I tried changing the name of the file, changing the names of the differents files...
by MAT
Mon Mar 31, 2003 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX performance statistics
Replies: 4
Views: 1637

Thanks BP, I thought it might be a bug too so I contacted Ascential on this and they are investigating the case. Meanwhile, what you are saying about post processing interests me. I am still a newbie with PX. Could you tell me more about dsrecords? Where should I enter it? I can't find a reference f...
by MAT
Fri Mar 28, 2003 12:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: PX performance statistics
Replies: 4
Views: 1637

PX performance statistics

Hi, As anybody tried to obtain stats from Parallel extender? When I check show performance statistics in designer, I always get zeros everywhere. The same happens while using the function DSGetLinkInfo() asking for row count (zeros all the way). I know for sure that there are records being transfere...
by MAT
Wed Mar 26, 2003 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logs
Replies: 6
Views: 2429

Christophe, To answer your question about accessing logs of jobs within a job sequencer. I talked with Ascential and it seems to be more complicated then I thought at first to get the job names in order to read the logs. The job names are easily viewable through DS Manager if you look at the job dep...