Search found 15603 matches

by ArndW
Fri Jun 24, 2005 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 2326

Kumar, I hate to admit it here, but I have years of COBOL experience on both host and mainframe - but I have never seen a PIC -B(4)9V99 datatype and have no idea how it might differ from either a 9-type or even a COM-x type. From the label it would seem to be "blank" but I remain at a loss. If you c...
by ArndW
Fri Jun 24, 2005 2:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence fails to compile ... but no error message
Replies: 3
Views: 1121

Sequence fails to compile ... but no error message

This is a very odd scenario - I have a simple sequencer that used to work to which I made a minor change and now it fails to compile, even when I revert the change. I get a compile-time popup window stating Error compiling Job Control Subroutine JsDSSFCRActCarBookPostSyncro . When I click on the "mo...
by ArndW
Fri Jun 24, 2005 1:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 2326

Kumar, thanks for the cut-and-paste. But you didn't really think about the real question. Anything in binary is in binary; there is no conversion done between an ASCII "binary" and an EBCDIC "binary" - in fact a binary field can, by definition, be neither ASCII nor EBCDIC. From your post you are rea...
by ArndW
Fri Jun 24, 2005 12:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Very slow job compile times
Replies: 3
Views: 1004

Vmcburney, I have seen that the C compiler on our machine has a limited number of licenses for concurrent use and the process will just sit there and twiddle-it's-thumbs waiting for a free slot; so we sometimes get long wait times because of that bottleneck. I've noticed similar seemingly inexplicab...
by ArndW
Fri Jun 24, 2005 12:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in PL/I Ebcdic File Read Using Parallel Seq Stage
Replies: 11
Views: 7625

I think that DataStage is padding the Bit fields to a byte boundary and thus getting an incorrect length computation. If this data is EDCDIC then you will want to ensure that the data is NOT being converted to ASCII as this would change all the bit flags. I would define this file as having just one ...
by ArndW
Fri Jun 24, 2005 12:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clean up a file through server routine?
Replies: 18
Views: 3133

This is a line termination issue. Under DOS or on PCs you typically have a <CR><LF> line termation character sequence. On UNIX the default is just to have a <LF>; as you were posting under a UNIX environment we assumed that you were using default termination. But then I made the mistake of using CHA...
by ArndW
Fri Jun 24, 2005 12:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 2326

Kumar,

instead of just writing an answer, let me pose a question to you:

What is the difference between a binary EBCDIC and a binary ASCII?
by ArndW
Thu Jun 23, 2005 10:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How To Pass Velues To Parameters
Replies: 9
Views: 2479

Titto, Suggestions/Questions: -are you getting an abort in the log file when opening in the file?, i.e. an incorrectly formed path? try putting "Counter += 1" and "CALL DSLogInfo(Counter,'')" inside the loop and seeing if it loops for each line. If you test from within the manager you will need to d...
by ArndW
Thu Jun 23, 2005 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stop a job with status ABORTED
Replies: 3
Views: 1208

Another method would be to use a Routine activity from a sequencer before re-calling your job "x"; in there use the DSGetJobInfo("x",DSJ.JOBSTATUS) to get the last run's status, return that code to the sequence and decide upon the action to do there.
by ArndW
Thu Jun 23, 2005 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why Rnd() function generates same number twice?
Replies: 10
Views: 2965

Craig,

this looks like a continuation of a thread last week; and if that is the case then the answer to your question "yes"
by ArndW
Thu Jun 23, 2005 5:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clean up a file through server routine?
Replies: 18
Views: 3133

Pavan, columns in your stages have the naming convention <stagename> [b].[/b ]<columnname> . Since we know neither your stage name nor your column name people will most often use examples like Link.Column or, in my case, In.Line or In.Column . All we are referring to here is the name of the column t...
by ArndW
Thu Jun 23, 2005 5:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File size
Replies: 14
Views: 3600

snassimr, no, none of these tools actually look at the disk size of the physical file, they only know about the logical view of the file and it's contents. You will need to use your OS and get that information from there. You do have a UV/Basic function called FILEINFO() which does give you a lot of...
by ArndW
Thu Jun 23, 2005 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why Rnd() function generates same number twice?
Replies: 10
Views: 2965

The only way to guarantee that you don't repeat a number when you use a RND function is to keep track of those number already used. If you seed your pseudo-random number a the same point you will get a reproduceable series - but it will, by definition, have duplicates. Another approach is to create ...
by ArndW
Thu Jun 23, 2005 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in PL/I Ebcdic File Read Using Parallel Seq Stage
Replies: 11
Views: 7625

Another way to do this, in addition to Ray's suggestion, is to declare the bit-level fields as CHAR (of appropriate length) and then use the OCONV(In.BitString,"MB0C") to get a longer character string with each character being a 0 or a 1.
by ArndW
Thu Jun 23, 2005 12:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp conversion
Replies: 23
Views: 5861

info_ds wrote:hi ray,

i tried and got the result --> 19950512

any suggestions?


No suggestions from anyone, it works just like it is supposed to.