Search found 464 matches

by WoMaWil
Thu Dec 13, 2007 2:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Transformer Stage Constraint" to be parameterised
Replies: 5
Views: 3012

Look into the Manual or go to a training session.

Code: Select all

Month=pMonth
by WoMaWil
Wed Dec 12, 2007 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mapping logic for XML output stage
Replies: 2
Views: 1106

XLM is for true a bit complicated. With your DataStage-CD come sample XLM-DataStage-Jobs and sample XLM-Input- aund XLM-Output-Files. Install them in on of your projects an look at them, you will learn for sure a lot about XLM and DataStage.
by WoMaWil
Mon Dec 10, 2007 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: importing .dsx file
Replies: 5
Views: 1487

with DataStage there are two Programm for to import on your Client PC:

dscmdimport.exe
dsimport.exe

both don't compile.

If you need such a programm you need to considerate dsmove, which is a third party tool. If you need details therefore send me an e-Mail.

Wolfgang.Huerter@HDI-Gerling.de
by WoMaWil
Mon Dec 03, 2007 9:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any command to export all jobs log to a text file i
Replies: 3
Views: 1555

If your Server is Windows you can write a batch file for to do it. Look into the manual after the dsjob-command.
by WoMaWil
Mon Dec 03, 2007 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stage Variable in a Routine
Replies: 3
Views: 1882

each routine has argument and which argument you put there is on your behalf, so you easily can do.
by WoMaWil
Mon Dec 03, 2007 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS mapping errors
Replies: 1
Views: 1012

On the FTP-way from one Operating System to an other operating System Errors can occur because they have different ways to store. DataStage is able to correct errors. Best way is to let transfer files that way that a file is readable with any tool in the target operating system. Therefor those who m...
by WoMaWil
Wed Nov 28, 2007 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems with ODBC and OCI stages
Replies: 1
Views: 1519

DataStage is a user on the server as yourself.

You have probably the nessary parameters for connection in your .profile.

DataStage has them in its dsenv-file.

Go and compare an restart DataStage.

For ODBC you have to configure the resp. ini-files.

Look into the manual for details.
by WoMaWil
Thu Nov 22, 2007 5:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrading DataStage 4.5 to 7.5.2 Env
Replies: 2
Views: 1202

you can also go via any 6.x Version as we did it.

Pay attention on each routine:

In past (before 5.x) you could do:

MyRoutine(Arg1)
Arg1=Arg1+25
Return(Arg1)

Now you have to change it like this:

MyRoutine(Arg1)
Arg2=Arg1
Arg2=Arg2+25
Return(Arg2)
by WoMaWil
Thu Nov 22, 2007 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Range Lookup
Replies: 5
Views: 1976

Dear Rumu, the solution depends a bit on how many pairs of RunNBRStart/RunNBRStart you have for a SupplierCode/Accnt pair. If that is not in a many thousands you can have the following solution for Hash-Stage-Solution. You keep supplier/accnt as key you make up an array for RunNBRStart/RunNBRStart/L...
by WoMaWil
Thu Nov 22, 2007 2:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to write the Routines/ Batch files in Server Jobs
Replies: 3
Views: 1660

open manager and follow the menu
by WoMaWil
Sat Oct 27, 2007 12:39 pm
Forum: Site/Forum
Topic: new Forum Event and Conferences
Replies: 5
Views: 5463

new Forum Event and Conferences

What do you think of a Forum where UserGroup Meetings and DataStage Conferences may be anounced?
by WoMaWil
Sat Oct 27, 2007 12:37 pm
Forum: General
Topic: next german-language DataStage UserGroup-Meeting
Replies: 1
Views: 1511

Thank you Ray for the hint with the user group. I will let it discuss on our next meeting. What might be of interest beside a separate UserGroup-intern Forum is a Forum for Events like this and may be several other UserGroup Meetings in other regions of Earth and Conference and so on.
by WoMaWil
Fri Oct 26, 2007 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic hashfile
Replies: 3
Views: 1030

Look through your jobs step by step. Maybe that somewhere in the lookup you have an other fieldtype or a blank so that the lookup is not met.
by WoMaWil
Fri Oct 26, 2007 1:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to copy a job
Replies: 4
Views: 2544

export the job.

open the dsx-file in an editor for example word.

change the Jobname (appears several times in the file) to the new name.

import the job.
by WoMaWil
Fri Oct 26, 2007 12:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automating export/import of DataStage jobs
Replies: 2
Views: 1361

There is a tool called "dsmove" which can do it (on Windows client) and there on the command line. If you need more details, send me an e-Mail.

Wolfgang.Huerter@hdi-gerling.de