Search found 15603 matches

by ArndW
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...
by ArndW
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...
by ArndW
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...
by ArndW
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

You can try to use a sequential file stage, declare it as a PIC X(9) and use the SDK conversion routine to convert from packed decimal to display to avoid any rounding errors by not using a floating point representation.
by ArndW
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

Dynamic CPU allocation is handled, but memory re-allocation is not, as it requires specialized calls which DS does not support.
by ArndW
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.
by ArndW
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 ...
by ArndW
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...
by ArndW
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...
by ArndW
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...
by ArndW
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

My misteak <sic>; the UNIX LF is CHAR(10)
by ArndW
Tue Jan 24, 2006 5:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequential files
Replies: 3
Views: 951

You can eliminate duplicate rows in sequential files by using any one or the many suggestions to be found by using the SEARCH facility found in this forum.
by ArndW
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

Add a line feed (Char(15)) to your derivation to add a line break.
by ArndW
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; ...
by ArndW
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

Julio, if you have MKS toolkit or something similar intalled, the rsh program might be an easy way to do it, or if the other machine is a windows-based one then (depending on your security setup and connections) you might be able to run the program directly using \\node\drive\program.exe syntax.