Search found 53125 matches

by ray.wurlod
Mon Apr 21, 2008 4:33 pm
Forum: IBM QualityStage
Topic: Capabilities of Quality Stage Version 8.0
Replies: 7
Views: 3499

All of those things can be done with version 7 (and therefore with version 8). You need the "real time" components for publishing the job as a web service, and you need CASS for US postal certification (certifying that an address is an existing address). If you have multiple address records "correct...
by ray.wurlod
Mon Apr 21, 2008 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get DataStage job User Name?
Replies: 5
Views: 1438

System variable @LOGNAME
Environment variable reference $USER

Gosh, it's the same answer to the same question you posted in the other forum!
by ray.wurlod
Mon Apr 21, 2008 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO CREATE ".o" & ".so" files for
Replies: 4
Views: 2036

The same way you do it on ANY box. This is fundamental C programming stuff.
by ray.wurlod
Mon Apr 21, 2008 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob command
Replies: 1
Views: 941

The same as for all DataStage processes. Execute the dsenv script to cover most of the bases, and ensure that APT_CONFIG_FILE and APT_ORCHHOME are correctly set.
by ray.wurlod
Mon Apr 21, 2008 5:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle stage problem
Replies: 4
Views: 1087

Design your job to have restart capability from a (parameterized) point.
by ray.wurlod
Mon Apr 21, 2008 5:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequencer problem
Replies: 4
Views: 958

It's a job sequence you're having a problem with, not a sequencer (which is a component you can used in a job sequence). What version of DataStage are you using - 7.5 or later, or earlier than 7.5? The answer will differ depending on your version number.
by ray.wurlod
Mon Apr 21, 2008 5:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: to convert the date format from yyyy-mm-dd to dd/mm/yyyy
Replies: 3
Views: 1203

If you are converting it to a Date data type it does not have a format. Date is stored in a binary form. Format only becomes relevant when it is being displayed, which means it's being converted to a string.
by ray.wurlod
Mon Apr 21, 2008 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About routines
Replies: 6
Views: 1257

There is nothing special about parallel routines - they are regular C++ functions. So is the calling mechanism.
by ray.wurlod
Mon Apr 21, 2008 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding Start_time and End_time of Job in Parallel Job
Replies: 3
Views: 881

The DSGetJobInfo() function will give you everything you need and more.
by ray.wurlod
Mon Apr 21, 2008 4:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server name and project name in email subject line
Replies: 12
Views: 5480

No space between the word Trim and its following left parenthesis.

No to your question about DSHostName.
by ray.wurlod
Mon Apr 21, 2008 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unix shell script
Replies: 1
Views: 819

Welcome aboard. DataStage is not the tool for this. Use a scheduler - either the one in the operating system (cron or at) or a third-party scheduler.
by ray.wurlod
Mon Apr 21, 2008 4:52 am
Forum: General
Topic: Retrieve User Name
Replies: 4
Views: 1285

System variable @LOGNAME
Environment variable reference $USER
by ray.wurlod
Mon Apr 21, 2008 4:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access on Oracle Tables
Replies: 1
Views: 1354

Moderator: please move to parallel forum

There are eight system tables to which you need access. Search the forum or read the documentation to learn what they are.
by ray.wurlod
Mon Apr 21, 2008 4:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine - Transform Function bug - missing Return(Ans)
Replies: 7
Views: 2065

Never seen that behaviour in any release. Can you try adding a comment after the final executable line? Also check that you don't have too many End statements in the code.