Search found 2288 matches

by roy
Sun Jun 26, 2005 4:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: odbc from ds on lnux to as400/db2
Replies: 4
Views: 1055

update:
adding this line:
IANAAppCodePage=<number>
to the .odbc.ini with <number> being 11 in the case mentioned got it working.

IHTH,
by roy
Sun Jun 26, 2005 4:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 2288 Phantom 16902
Replies: 4
Views: 1034

Hi,

Code: Select all

man find

would get you on your way to learn you also need { } there and perhaps some more cahracters.
Your best freind in this should be your sys admin on the unix end.

IHTH,
by roy
Sun Jun 26, 2005 2:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to initialize importer
Replies: 4
Views: 2984

Hi,
No offence, but IMHO, having 100 posts means you should know we need more info then an arbitrary error code!

Again no offence just pointing to something that is preventing most people here from being able to help and/or benefit from your post.
by roy
Thu Jun 23, 2005 9:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom
Replies: 4
Views: 1236

Hi,
I posted a while back how to get to the info you need.
Do search for it.

IHTH,
by roy
Thu Jun 23, 2005 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reset multiple instances of job
Replies: 3
Views: 2244

Hi, Depends on what you need. Compiling the job will clear all instances and make them run-able, but is this something you can live with? other then that can you get the list and prepare each job? (DSPrepareJob or running them with reset option) I do remember having problems resetting multi instance...
by roy
Thu Jun 23, 2005 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Add transaction feature to sql statement
Replies: 3
Views: 1203

Hi,
did you try using user defined sql with lets say:
set lock mode to wait n; select ......
?
by roy
Thu Jun 23, 2005 6:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: '£ ' getting converted to '#'
Replies: 6
Views: 2604

Hi,
Do you have NLS enabled in your server?
If not you might need to install it first.
Then choose the proper NLS for the stage.

(Some how I vaguely recall something regarding support of the euro sign, so I wonder if one exists for the pound as well?)

IHTH,
by roy
Thu Jun 23, 2005 6:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stop a job with status ABORTED
Replies: 3
Views: 1208

Hi, If I undesrtand you, you want to check if the last run finished successfully otherwise you want the job to abort. So do a sequence job. Th first job activity should be one that reads from your REPORT table and searching for the finished flag. If you don't find it use the DSLogFatal() ( not recom...
by roy
Thu Jun 23, 2005 3:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File size
Replies: 14
Views: 3600

Hi, You might be able to do it via universe commands. Perhaps by analyze.file command. It really depends on what implementation you had in mind. why you need to know the exact file size? will you use both dynamic and static files or not? what do you want gain by having this data? and so on. so pleas...
by roy
Thu Jun 23, 2005 3:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Updating Z_RFC_DS_SERVICE function
Replies: 1
Views: 881

Hi,
I think the update issue is really for SAP people.

Nothing else Ican add beyond the upgrade manuals you need to go thru.

IHTH,
by roy
Thu Jun 23, 2005 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Phantom error 10819
Replies: 5
Views: 3123

Hi, 10819 is not an error code! this is what's wrong: writeSocket() returned 39 Program "DSD.OshMonitor": Line 322, Variable "finished" previously undefined. Zero used. writeSocket() returned 16 it really sound like a support call to me. you might also need some patch/es regarding your job monitor s...
by roy
Thu Jun 23, 2005 2:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reset all jobs problem
Replies: 2
Views: 1712

Hi, First I don't understand why do you need to reset all jobs? you can use via sequence jobs the reset if required then run. you can use the DSPrepareJob(<jobHandle>) to reset if required from DS basic code before running them. Now if you run jobs directly (not via DS basic or sequence jobs) you do...
by roy
Thu Jun 23, 2005 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: best practices
Replies: 5
Views: 1669

Hi,
your next best thing is this forum, your support and the advanced developers guide.
by roy
Wed Jun 22, 2005 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: merge
Replies: 7
Views: 1744

Hi,
usually it's in the output tab under the input files properties under first or second file format tab.
naturally the settings there must match to the actual ones of the file.
IHTH,
by roy
Wed Jun 22, 2005 4:41 am
Forum: IBM QualityStage
Topic: RealTime QS
Replies: 3
Views: 2437

Hi, Mentioning of real time and large amounts of data at the same breath??? Could you specify more details? usually real time means handling of 1 request individually. SOA (former RTI) allows you to have n instances of a process at any givven time after you exceed that number you might create a bott...