Search found 11 matches

by bkerebel
Tue Sep 03, 2019 6:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to generate the schema file using ds job
Replies: 10
Views: 23977

Hi,
to create automatically a schema file in DS 11.5 (I think it was the same before)
1) save the table definition
2) open the saved table definition
3) go to Layout
4) activate the Parallel view
5) copy / cut the schema file auto generated to a schema file in your server

Have a nice day
by bkerebel
Mon Sep 02, 2019 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of special characters as delimiter in sequential file
Replies: 8
Views: 11997

Hi all, for information if you have trouble to use a special delimiter or quote character to read a Sequential file, you can use a schema file and the import column Exemple : if you use double quote for the quote, you can use ASCII value record {final_delim=end, delim='|', quote="\0"} ( IN...
by bkerebel
Tue Feb 06, 2007 9:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what is DSJ.ME ?
Replies: 7
Views: 6803

hi,
the syntax is

v_jobName = DSGetJobInfo (DSJ.ME,DSJ.JOBNAME)

and then you can use v_jobName to do

ErrCodeRun = DSRunJob(v_jobName, DSJ.RUNNORMAL)

Bertrand
by bkerebel
Tue Feb 06, 2007 9:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what is DSJ.ME ?
Replies: 7
Views: 6803

hi,
DSJ.ME is to handle a job and do some actions on it, like running the job, testing status or errors

you can find some infos in how can we reset a datastage job using datastage coding or other topics (for job control). search DSJ.ME

Bertrand
by bkerebel
Tue Feb 06, 2007 8:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP error
Replies: 20
Views: 5767

I just wanted to say than in "after job" you can use something doing the same job

and if ftp in telnet works, the "after job" function would manage where ftp stage is sporadic

Bertrand
by bkerebel
Tue Feb 06, 2007 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Non-equijoin Key Expression
Replies: 15
Views: 5102

hi, if I have trouble about expressions like that, I do one variable for each TRUE expression, and then it's very easy to debug, vars : true_1 : if NOT(LookUpFile.NOTFOUND) then @true else @false true_2 : X <> Y or P <> Q or A <> C then @true else @false derivation : true_1 AND true_2 and then your ...
by bkerebel
Tue Feb 06, 2007 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to abort a job in Afterjob sub routine
Replies: 18
Views: 5552

perhaps you could use too the
Call DSFatalInfo(xxx, yyy) to give a fatal message into your log

Bertrand
by bkerebel
Tue Feb 06, 2007 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pipe Broken
Replies: 5
Views: 2002

hi, in a lot of situations, abort after 700 rows is the same about 0 rows, job treating 700 rows each time. then I think you have aborted directly then, pipe file is not a file you want to write in, but it's only a null file, always 0 bytes, where your data is traveling but never it stops.. your des...
by bkerebel
Tue Feb 06, 2007 7:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: problem with dsx file
Replies: 7
Views: 2352

Line 63952: Unknown property name '"'. Object=SubObject of ROOT. Class=CParameters. it's near strange.. no property, and the object is a ROOT object. perhaps your project has change about rights for some files and then your user is not able to import the file if you were in unix platform you c...
by bkerebel
Tue Feb 06, 2007 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP error
Replies: 20
Views: 5767

hi,
a good thing about datastage is that you can use whenever oracle functions, unix functions, universe functions

then in before job or after job, as you like, you can use a system function, like rcp if you're in unix platform. if telnet is ok, I think rcp will be ok too
by bkerebel
Tue Sep 26, 2006 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [Server] dsjob returncode list
Replies: 3
Views: 3246

[Server] dsjob returncode list

hi,
I work in Unix interface
sequencers are started with Autosys (automation scheduller interface)

I've sometimes a server sequencer started with Unix script, using dsjob, finishing with returncode 6

I can't find dsjob returncode list

best regards to person giving me this list