Search found 15603 matches
- Wed Jan 25, 2006 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width files
- Replies: 6
- Views: 1410
Re: Fixed width files
Puli.reddy, in your first post you stated ...I am facing a problem to read data from fixed width files... and now you are stating that you know the file is not fixed width? If you declare your column definitions correctly and also specify the correct sequential file attributes (column separators, li...
- Wed Jan 25, 2006 1:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width files
- Replies: 6
- Views: 1410
Your file is not fixed-width format or in a different format than you think. In order for it to be fixed width it would need spaces (otherwise your line 1 and line 2 would have different lengths!). It has EOR (end-of-record) terminators and one was encountered while parsing your input data. You need...
- Wed Jan 25, 2006 1:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable toStart Datastage resource Engine Service
- Replies: 5
- Views: 1873
Sometimes things get in a state where the service won't start - often when they didn't shut down correctly. The simplest solution would be to restart your Windows server. I think that the timed error message comes when a resource DS needs is not given to it, particularly one of the listener ports. W...
- Wed Jan 25, 2006 1:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal value gets rounded up
- Replies: 9
- Views: 2695
- Tue Jan 24, 2006 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Will PX work with dynamically allocating LPAR's on AIX/DB2?
- Replies: 4
- Views: 1579
- Tue Jan 24, 2006 10:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: can not open job activites in a job sequencer
- Replies: 2
- Views: 1315
Supernova,
many others have had the same problem and the questions as well as answers have also been posted. The SEARCH facility should be a core part of DSXchange usage as it will locate the answers to your question. I used it to get many responses, including this one.
many others have had the same problem and the questions as well as answers have also been posted. The SEARCH facility should be a core part of DSXchange usage as it will locate the answers to your question. I used it to get many responses, including this one.
- Tue Jan 24, 2006 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal value gets rounded up
- Replies: 9
- Views: 2695
Kumar, floating point numbers are represented as a number and an integer exponent of e . Since the precision of the number is limited, not all possible real numbers can be correctly represented and by setting the APT_DECIMAL_INTERIM_ROUND_MODE to round to the nearest representable value it is quite ...
- Tue Jan 24, 2006 8:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Improve Performance by reducing if clauses in Transformer
- Replies: 8
- Views: 2256
The compiled code will have to evaluate all conditions in an IF statement joined by AND before branching; so changing your IF statement to use the most common branches first will reduce the number of instructions required significantly. If you look at your job's monitoring information the %CPU utili...
- Tue Jan 24, 2006 7:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: o/p is seq file how get data into in newline
- Replies: 4
- Views: 1371
I thought I had remembered it correctly but did a quick check in the BASIC PDF document before posting and managed to look at the octal column by mistake and managed to get the post wrong. I wouldn't have caught the error if another person hadn't posted the exact same question in a separate thread a...
- Tue Jan 24, 2006 7:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage
- Replies: 2
- Views: 1193
Venkat, transforms are 1-line codes that are replaced at compilation time; whereas routines are functions that can be of any length you want and are called at runtime. If you change a transformation you need to recompile all jobs that use it; you need only recompile a routine once so that the change...
- Tue Jan 24, 2006 5:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to print in next line
- Replies: 8
- Views: 2572
- Tue Jan 24, 2006 5:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: sequential files
- Replies: 3
- Views: 951
- Tue Jan 24, 2006 5:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to print in next line
- Replies: 8
- Views: 2572
- Tue Jan 24, 2006 5:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: o/p is seq file how get data into in newline
- Replies: 4
- Views: 1371
Most Windows files use <CR><LF> as the line separator. All you need to do is to add those to characters to your line and it will ensure a line break. A Derivation such as "'Hello how are you ':CHAR(13):CHAR(10):#ParameterName#" will do this. (Please note, I corrected the original CHAR() defintions; ...
- Tue Jan 24, 2006 4:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to invoke programs in a remote server
- Replies: 2
- Views: 916