Search found 53125 matches

by ray.wurlod
Sat Apr 19, 2008 4:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert TimeStamp
Replies: 2
Views: 1625

This is one you will need to write yourself. What exactly is in the time zone column?
by ray.wurlod
Sat Apr 19, 2008 4:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do i check the return value of a routine ?
Replies: 2
Views: 1066

Reverse your logic. By default an OK trigger fires if the return value is 0, a failure trigger fires if the return value is non-zero.
Otherwise create custom trigger to handle 0 as a failure, and a Failure trigger to handle your "1 is good" case.
by ray.wurlod
Fri Apr 18, 2008 4:19 pm
Forum: General
Topic: Difference between ORACLE Enterprise and DRM (Dynamic) Stage
Replies: 7
Views: 2177

Oracle Enterprise uses system tables to determine whether and, if so, how the table is partitioned.
by ray.wurlod
Fri Apr 18, 2008 4:17 pm
Forum: General
Topic: Dynamically renaming variables
Replies: 8
Views: 2481

I would use a Copy stage rather than Modify or Transformer, unless I had other processing to do on the data. Copy stage is very efficient - all it does is transfer from input to output.
by ray.wurlod
Fri Apr 18, 2008 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding NLS MAP
Replies: 5
Views: 2981

For starters disable operator combination so you can determine which stage is throwing the error. Somewhere in your data is a character that does not exist in the ISO8859-1 character map. You will need to monitor your data to determine the row in which this occurs then seek out the unmappable charac...
by ray.wurlod
Fri Apr 18, 2008 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help on 'Make Vector' Stage
Replies: 1
Views: 760

Welcome aboard. As a matter of principle we resent "ASP" requests. DSXchange is an all-volunteer site whose participants post as and when they can. If you want urgent help, sign up with your support provider for premium service, and learn that there is a true cost associated with "urgent". A vector ...
by ray.wurlod
Fri Apr 18, 2008 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2465

evdf&!DS.ADMIN!& is a special value that is used to create a shared lock of the same name to indicate that there is a client connected to the evdf project. This is used by several Administrator utilities to check quickly whether they can have exclusive access (no connected clients) to the pr...
by ray.wurlod
Fri Apr 18, 2008 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warnings in sort and remove duplicate stages.
Replies: 2
Views: 989

Moderator: please move to parallel forum
by ray.wurlod
Fri Apr 18, 2008 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File nane with date
Replies: 25
Views: 10315

Moderator: please move to parallel forum
by ray.wurlod
Fri Apr 18, 2008 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sorting & partiotining
Replies: 2
Views: 992

Moderator: please move to parallel forum
by ray.wurlod
Fri Apr 18, 2008 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server "Rows per Transaction" size
Replies: 4
Views: 1485

0 means "all rows" are one transaction.
by ray.wurlod
Fri Apr 18, 2008 3:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: write range map sample code
Replies: 1
Views: 1844

Welcome aboard. Moderator: please move to parallel forum The Write Range Map stage takes any input in which at least one column is identified as Key. It figures out the values of the key that give the most even spread of records when Range partitioning is used subsequently on the data, and writes th...
by ray.wurlod
Fri Apr 18, 2008 3:42 pm
Forum: General
Topic: Counting number of records in Hashed File
Replies: 4
Views: 1746

They are all right. There are 41 records containing the string HashedFile in the OLETYPE column. There are 14 records for which the value of OLETYPE is "CHashedInput" and there are 25 records for which the value of OLETYPE is "CHashedOutput". This is exactly the same result you would get if the data...
by ray.wurlod
Fri Apr 18, 2008 6:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: record count of all tables
Replies: 10
Views: 2652

Of course you can do it, but your script would either need to lock in the names of the tables or the names of the jobs. Discovery is possible, but your script will become rather unwieldy.
by ray.wurlod
Fri Apr 18, 2008 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to append to an existing sequential file using routine?
Replies: 5
Views: 1451

OpenSeq FilePath : FileName To TempFile On Error Ans = "Error (code " : Status() : ") opening file." End Locked Ans = "File in use by user number " : Status() End Then * File exists and opened. Need to position to EOF. Seek TempFile , 0, 2 Then ...