Search found 53125 matches

by ray.wurlod
Wed Sep 15, 2004 4:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Converting String field to Time field
Replies: 15
Views: 3669

This is even cleaner. It uses a mask in the Fmt function to insert the colon characters.

Code: Select all

Ans = Iconv(Fmt(Arg1, "6'0'R##:##:##"), "MT")
by ray.wurlod
Wed Sep 15, 2004 4:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to read Hash file column name and type through Admin?
Replies: 4
Views: 1964

The file dictionary (metadata) for a hashed file is stored in its "file dictionary". You get at this by preceding the hashed file name by the DICT keyword in a query; without the keyword you see the actual data. In UniVerse SQL: SELECT "FIELD", "FIELD.TYPE", "FIELD.DEF"...
by ray.wurlod
Wed Sep 15, 2004 4:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI truncated Date
Replies: 11
Views: 3289

With no size, DataStage is trying to get at NUMBER(0) items. If they're integers, Oracle requires NUMBER(38) - not NUMBER(40). Try it with 38 instead of 40.
by ray.wurlod
Wed Sep 15, 2004 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calculating MEDIAN (instead of AVERAGE)
Replies: 6
Views: 3753

If you think about it, you cannot calculate median without sorting the data set. You also need the total row count (let's call it N) so that you can determine the (N/2)th position. Slight variations depend on whether N is odd or even, but you can use Int(N/2+1) with no loss of generality. A DataStag...
by ray.wurlod
Wed Sep 15, 2004 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Learning Basic Programming
Replies: 5
Views: 2276

At a pinch you could enrol on IBM's UniVerse Database Programming class; however only about 60% of that is relevant to DataStage, the remainder dealing with terminal I/O and other user interactions.
But it is scheduled more regularly than Ascential's.
by ray.wurlod
Tue Sep 14, 2004 11:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI truncated Date
Replies: 11
Views: 3289

What are reported in the following situations?

(a) importing the table definition through the OCI plug-in, what data types are reported?

(b) do you get the same message from Oracle when using something else such as sqlplus or TOAD?
by ray.wurlod
Tue Sep 14, 2004 8:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logs of deleted jobs
Replies: 4
Views: 1365

It now remains only to allocate blame! :lol:
by ray.wurlod
Tue Sep 14, 2004 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Find day of the next month
Replies: 6
Views: 1842

When in Designer or Manager invoke Help. Select the topic BASIC Tasks . Drill down from there: Data Formatting Oconv (read it all) (at this point you will have all the codes - follow the hyperlink to each for detailed explanation and examples) In the DataStage BASIC manual read the appendix called "...
by ray.wurlod
Tue Sep 14, 2004 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logs of deleted jobs
Replies: 4
Views: 1365

Yes there is, though it has no client interface. The name of the table is DS_AUDIT, and it records creation, modification and deletion. I have posted the column names for this table before; search for them. The two you're particularly interested in are PREVDTD and PREVDELETOR. Of course, only the mo...
by ray.wurlod
Tue Sep 14, 2004 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To Highlight the Header in server job
Replies: 5
Views: 1414

DSSendMail is merely an interlude to sendmail(), an extremely basic mail client. I believe, to make use of extended functionality, you will need to use a more capable mail client. You are trying to get DataStage functions (and the UNIX function) to perform a task that was not within their design spe...
by ray.wurlod
Tue Sep 14, 2004 4:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dscmdexport.exe Backups failing..
Replies: 5
Views: 1903

DS.REINDEX rebuilds secondary key indexes on the Repository tables. It also reports what it has done. You can examine the paragraph using the following command LIST.ITEM VOC 'DS.REINDEX' in which you will see that it's a series of recursive calls each of which builds the indexes on a specific table....
by ray.wurlod
Tue Sep 14, 2004 1:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dscmdexport.exe Backups failing..
Replies: 5
Views: 1903

Welcome aboard! :D Can you export the project (or even some of it) from the Manager client? If not, you will begin to suspect that indexing in the DataStage repository has somehow gone awry, and you probably need to fix it. There are two ways: from the Administrator client Command window, execute th...
by ray.wurlod
Tue Sep 14, 2004 12:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Learning Basic Programming
Replies: 5
Views: 2276

Ascential have on the books, but not scheduled, a class called Programming with DataStage BASIC . It can be offered on demand, as far as I know. It was most recently revised for version 4.x, but the language hasn't changed that much. UniVerse manuals can be downloaded for no charge from IBM website ...
by ray.wurlod
Mon Sep 13, 2004 4:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link
Replies: 2
Views: 684

Welcome aboard! :D In your design, have you changed the name of a link but not changed a derivation that is based on a column from that link? Otherwise, try using Save As to save the job under a different name, and compiling the new version. Any routine with a "DSD." prefix is used internally by Dat...
by ray.wurlod
Mon Sep 13, 2004 4:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Routines in Transformer
Replies: 16
Views: 4715

Try coding without using DATA as a variable name. DATA is a reserved word in DataStage BASIC.