Search found 27 matches

by mickboland
Mon Mar 20, 2006 8:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add/minus months function
Replies: 11
Views: 6362

Ray,

No date functions!!
by mickboland
Mon Mar 20, 2006 12:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add/minus months function
Replies: 11
Views: 6362

how?

How would you take 4 months from the date 20/01/06 (ie: return a date of 20/09/05).
by mickboland
Sun Mar 19, 2006 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add/minus months function
Replies: 11
Views: 6362

add/minus months function

Is there a standard function to add or take away months from a date.
by mickboland
Wed Oct 12, 2005 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SMTPMail RCV: 550 5.7.1 Unable to relay
Replies: 5
Views: 4886

i used the correct smtp server name
by mickboland
Wed Sep 28, 2005 11:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using @USER0 in Sequential stage file name
Replies: 8
Views: 3319

thanks ray - i will tinker with this rename method.


Is there a way to get the filename that the job has assigned to the seq file?
by mickboland
Wed Sep 28, 2005 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using @USER0 in Sequential stage file name
Replies: 8
Views: 3319

I need to set the parameter value at runtime.
by mickboland
Wed Sep 28, 2005 7:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using @USER0 in Sequential stage file name
Replies: 8
Views: 3319

is there any way to dynamically set the filename apart from job parameters?
by mickboland
Wed Sep 28, 2005 7:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using @USER0 in Sequential stage file name
Replies: 8
Views: 3319

using @USER0 in Sequential stage file name

I know you can use job parameters in a Sequential file stage filename eg:
#$EXTRACTS#\#CONNECTORSCRIPTNAME#_#RICEF# REJECTED.csv


Is there a way to use @USER0 in the Filename of a Sequential file stage?
by mickboland
Wed Sep 28, 2005 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: setting parameter value in befor job routine
Replies: 3
Views: 2198

any way of adding a version number to an output seq file eg: c:\data\result #version#.csv

can you read a value from an input link an use it in the output filename?
by mickboland
Wed Sep 28, 2005 6:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: setting parameter value in befor job routine
Replies: 3
Views: 2198

setting parameter value in befor job routine

I could be using the wrong approach but here i go: What i want: I want to add version numbes to the seq files that my jobs create eg: c:\data\result #version#.csv My Approach: 1. create a job parameter called version 2. add a before job routing to set the version parameter to a new value (using the ...
by mickboland
Sun Sep 25, 2005 5:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: command line functins that import and export the DS jobs
Replies: 23
Views: 13546

The reason I use the xml export is that I have written a xsl that delivers the whole project as a web document.

To update the page I just need to replace the old project export with the new one.
by mickboland
Wed Sep 21, 2005 5:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export job image as jpg unattended
Replies: 9
Views: 4197

he uses the same cmd - but it is not unattended the function returns message boxes
by mickboland
Wed Sep 21, 2005 6:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export job image as jpg unattended
Replies: 9
Views: 4197

Export job image as jpg unattended

I use the cmd:

dsdesign.exe /H=%Host% /U=%User% /P=%Password% /SaveAsBmp=%BackupDir%\%DsxDate%\%%.bmp %Project%

to export the job image to a jpg. This issue i have is that it is interactive ie: dialogs pop up it a warning occurs etc..

Is ther any way to export the image of a job unattended?
by mickboland
Wed Sep 21, 2005 6:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: command line functins that import and export the DS jobs
Replies: 23
Views: 13546

Is there any way to export the full project to XML from the cmd line?
by mickboland
Wed Sep 21, 2005 5:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: command line functins that import and export the DS jobs
Replies: 23
Views: 13546

Is there any way to export the full project to XML?