Search found 15603 matches
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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
- 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...
- 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
- 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
- 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...
- 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...
- 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 ...
- 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
- 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