Search found 53125 matches

by ray.wurlod
Mon Mar 07, 2011 8:16 pm
Forum: General
Topic: How to Alter User defined variables within a sequence
Replies: 10
Views: 11530

You could possibly use a User Variables activity ahead of the loop to initialize the variable, and a User Variables activity within the loop to increment. Note that this is an idea that I have not investigated. Is the loop a counted loop? In that case you could simply add that to the initial value. ...
by ray.wurlod
Mon Mar 07, 2011 6:43 pm
Forum: General
Topic: Fix Pack1 for DataStage Client
Replies: 7
Views: 3871

Or think about version 8.5, in which the installer is completely revamped and, for want of a better adjective, beautiful.
by ray.wurlod
Mon Mar 07, 2011 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Stage Parameter Issue
Replies: 6
Views: 4244

It appears that ALL Connector stage types with database connectivity exhibit this behaviour. I am seeing the same in the ODBC Connector stage in version 8.5. Methinks an enhancement request is in order.
by ray.wurlod
Mon Mar 07, 2011 6:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date in file name : Logic to abort.
Replies: 10
Views: 2843

Don't even start the job if your condition is not met. Test it in a sequence.
Where does the file name come from? Simply extract the date component from that, reformat the date appropriately and compare it to your criterion date in an Execute Command activity.
by ray.wurlod
Mon Mar 07, 2011 3:31 pm
Forum: General
Topic: Fix Pack1 for DataStage Client
Replies: 7
Views: 3871

Have you downloaded the correct version of the Update Installer (a Java app that installs fix packs)?
by ray.wurlod
Mon Mar 07, 2011 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: change line break from CR to CR/LF
Replies: 14
Views: 6405

Get yourself a copy of WinSCP, which can look after all that for you. Or use "proper" FTP.
by ray.wurlod
Mon Mar 07, 2011 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between Oracle OCI and Enterprise Stage
Replies: 1
Views: 2079

There's a lot of difference, which even a cursory reading of the manuals would reveal. Is this an interview question? Essentially, the Oracle OCI stage is used in server jobs and has no innate parallelism, whereas the Oracle Enterprise stage is used in parallel jobs and can handle parallel execution...
by ray.wurlod
Mon Mar 07, 2011 3:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Enterprise Fatal Error
Replies: 1
Views: 1517

Are there any related errors/warnings in the log?
by ray.wurlod
Mon Mar 07, 2011 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to update the Hash file in the server Basic language
Replies: 9
Views: 3534

What is the desired output? Also, you need (a) to use READU to read for update (b) to RELEASE the lock if you choose not to WRITEV The syntax of your WRITEV command is correct, but you might like to add ON ERROR and ELSE clauses to report whether it fails, in which case the STATUS() function will gi...
by ray.wurlod
Mon Mar 07, 2011 3:22 pm
Forum: General
Topic: Reset the loop when processing data
Replies: 3
Views: 2047

There is no way to reset the loop index variable. You can design to bypass activities. ---> Start Loop <---------------------------------- End Loop | ^ | | V | Nested Condition -----> Job Activity -----> Sequencer | ^ | | +----------------------------------------------+
by ray.wurlod
Mon Mar 07, 2011 3:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion Function
Replies: 1
Views: 874

It's in the manual. Use decimal_from_string().
by ray.wurlod
Mon Mar 07, 2011 3:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File layouts & their import methods
Replies: 1
Views: 890

Yes, from what you've provided, there is more than one RecordDef.

It looks like someone has re-organized a COBOL copybook, though I'd be concerned about the duplicate appearance of PathRidCode.
by ray.wurlod
Mon Mar 07, 2011 3:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delimiter representation
Replies: 1
Views: 1132

If it's during import of the sequential file's table definition, specify the decimal value of the ASCII code (that is, 127).
by ray.wurlod
Sun Mar 06, 2011 11:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to update the Hash file in the server Basic language
Replies: 9
Views: 3534

Unemployment is "not working".

You'll have to be more specific.
by ray.wurlod
Sun Mar 06, 2011 7:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic Data Reconciliation
Replies: 22
Views: 12193

Yes, I was. Notice the "resolved" status, though.
:wink:
:D