Search found 53125 matches

by ray.wurlod
Thu Jul 08, 2004 6:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete jobs
Replies: 13
Views: 3973

You bet.

Arlo Guthrie is touring (or has just toured) here at the moment. Brought back a few memories, even though he doesn't do "that song" any more. Also, I ride a motorcycle.

echo "$DEITY has called in sick."
by ray.wurlod
Thu Jul 08, 2004 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between Datastage's release 6x and 7x
Replies: 6
Views: 2008

The release notes include a section on what's new in the current release. This should provide a fairly comprehensive summary.
by ray.wurlod
Thu Jul 08, 2004 5:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading variable length records in Sequencial Stage
Replies: 9
Views: 4394

The "why" is almost certainly an issue with your constraint and/or derivation expressions. Are you able to post your design overview, with the actual constraint expressions that you're using?
by ray.wurlod
Thu Jul 08, 2004 5:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML2 Reader and ">" Character
Replies: 11
Views: 4291

... and, on that basis, you go back to the providers of the XML file and complain bitterly to them that what they're sending to you is not well-formed XML and therefore impossible to process, and require that they do send you well-formed XML.

It why we have standards!
by ray.wurlod
Thu Jul 08, 2004 4:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [Resolved]Promoted jobs with Version Controll
Replies: 5
Views: 1240

When you promote using Version Control, do you take advantage of the "auto-compile" feature?
by ray.wurlod
Thu Jul 08, 2004 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-08177: Cannot serialize access for this transaction
Replies: 5
Views: 2477

:idea:
The Oracle error codes manual contains not only the meaning of each error code but also, in most cases, suggested remedial action. It's worth having nearby when you're working with Oracle.
by ray.wurlod
Thu Jul 08, 2004 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete jobs
Replies: 13
Views: 3973

The Cleanup button for the project in the Administrator client, as one of its tasks, seeks out and deletes any such "orphaned" Repository objects.
by ray.wurlod
Wed Jul 07, 2004 4:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capture of Job Log Entries
Replies: 2
Views: 864

Since a job log is a table in the Repository, you can also use SQL, executed within the DataStage environment on the server or through the Administrator client Command window. SELECT TIMESTAMP, SEVERITY, FULL.TEXT FROM RT_LOGnnn WHERE @ID NOT LIKE '//%' ORDER BY @ID; where nnn is the job number obta...
by ray.wurlod
Wed Jul 07, 2004 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capture of Job Log Entries
Replies: 2
Views: 864

There is a series of functions for capturing log information. DSGetLogSummary DSGetNewestLogId DSGetLogEntry You can use these within DataStage BASIC code, for example in a job control routine or in a before/after subroutine. Statements for working with text files include OpenSeq , WeofSeq , WriteSe...
by ray.wurlod
Wed Jul 07, 2004 3:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing a Progress Database table definition
Replies: 8
Views: 2333

Does the user ID you're using have privileges sufficient to SELECT the system tables in the Progress database?
What are the permissions on the PROMSGS file?
by ray.wurlod
Wed Jul 07, 2004 3:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading variable length records in Sequencial Stage
Replies: 9
Views: 4394

Sounds like A=header, B=detail and C=trailer.
Search for these terms on this Forum to get more ideas.
There are at least three different solutions, even without using a Complex Flat File stage.
by ray.wurlod
Wed Jul 07, 2004 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while renaming
Replies: 8
Views: 1670

Overkill.

All you needed was

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME = 'MyJobName';
perhaps through the Administrator client Command window.
by ray.wurlod
Wed Jul 07, 2004 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Information
Replies: 4
Views: 1071

If it is, it's in the online help, and you will find the constant in a file called JOBCONTROL.H in the dsinclude directory.
If it's in neither place, then it's not available in 6.0r3. My routine will work for all releases back to when multi-instance jobs were introduced (5.1?).
by ray.wurlod
Wed Jul 07, 2004 2:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mainframe upload of Jobs
Replies: 1
Views: 774

The COBOL and JCL are generated by DS390 into files on the server. You specify the location! You can upload them from there by any means you like. However, the Upload button is constrained - as far as I am aware - to using FTP and the properties specified in the machine profile. (You marked your pos...
by ray.wurlod
Wed Jul 07, 2004 2:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Licensing and mulithreading
Replies: 5
Views: 2122

Some plug-ins are chargeable! :?
Mainly those for which Ascential must pay a licence fee of some kind, such as the SAP extract and BW Load plug-ins.

It's only 6:30pm on the east coast, 4:30pm in Perth (last stop before Jo'burg)!