Search found 42189 matches

by chulett
Mon Jun 10, 2013 6:46 am
Forum: General
Topic: Automated conversion of DataStage version 7.5.1A
Replies: 2
Views: 1373

There's no tool needed. Importing them into 'the latest version' will do whatever is needed automagically.
by chulett
Mon Jun 10, 2013 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ANSI to UTF-8
Replies: 9
Views: 10114

Have you considered that perhaps your "download" step is affecting the file format? What does it test as if you check it directly on the UNIX server using 'file'? And you certainly don't need a DataStage job to convert the file, iconv from the command line would do it but you'd have to cla...
by chulett
Mon Jun 10, 2013 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal To String Conversion
Replies: 10
Views: 6523

Can you post the actual conversion error? Sorry, just trying to get all of the forensic information here.
by chulett
Mon Jun 10, 2013 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal To String Conversion
Replies: 10
Views: 6523

I assume you've tried using the DecimalToString() function, can you detail for us the issues you've had with that? I'd also be curious what your CAST looks like to see how you are handling it there.
by chulett
Mon Jun 10, 2013 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Truncate and Round Float type data
Replies: 3
Views: 1641

Can you post some input and output examples, please?
by chulett
Sun Jun 09, 2013 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regex pattern
Replies: 7
Views: 1788

ray.wurlod wrote:Another approach is to use the Data Rules stage, which includes a genuine matches_regex rule.
This looks like it was included starting with the 8.7 release. And it is part of the base release rather than optional 'licensed for a fee' functionality. Is that correct?
by chulett
Sun Jun 09, 2013 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regex pattern
Replies: 7
Views: 1788

OK. Investigate the use of the Index() function for this.
by chulett
Sat Jun 08, 2013 8:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of Link_Collector_64 detected in DS 8.5
Replies: 2
Views: 2488

If you haven't done so already, do an exact search here for "timeout waiting for mutex", I got 85 matches so there should be plenty of information out there. One thing to note - any stage where you can set a timeout value will timeout at some point, it's the nature of the beast and why I t...
by chulett
Fri Jun 07, 2013 7:46 pm
Forum: General
Topic: RT_ Folders in the Datastage Project Dir on the Server
Replies: 4
Views: 2210

Ah, right... forgot to include that. The .O is for "Object code", as noted the compiled BASIC code.
by chulett
Fri Jun 07, 2013 7:44 pm
Forum: General
Topic: using dsjob with parameters
Replies: 14
Views: 4473

Found some documentation online for it but it's all text with no images. I don't see how the 'command' is built that the stage executes. You would need to pre-build the command string with the values substituted in as I noted, can you do that in a preceding Transformer and then have the Command stag...
by chulett
Fri Jun 07, 2013 3:30 pm
Forum: General
Topic: using dsjob with parameters
Replies: 14
Views: 4473

I would like to attach a print screen or a document with the image embedded but I don't know how. All web boards like this support embedded images - that's what the Img or Images tags are for. First, however, you'd need to host your image file somewhere but there are a ton of free sites available f...
by chulett
Fri Jun 07, 2013 3:28 pm
Forum: General
Topic: using dsjob with parameters
Replies: 14
Views: 4473

I'm not familiar with that stage as it is exclusive to Windows servers and I've always worked in the UNIX world. Help me out here as I have no windows documentation - are you using it inside a Server job or a Sequence job?
by chulett
Fri Jun 07, 2013 3:25 pm
Forum: General
Topic: RT_ Folders in the Datastage Project Dir on the Server
Replies: 4
Views: 2210

BP = BASIC Program from what I recall.
by chulett
Fri Jun 07, 2013 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Phone Number Format
Replies: 2
Views: 1629

Build the pieces with separate expressions concatenated together:

Code: Select all

Isnull(Lnk_Cpy_Ds.Ph1) OR (Lnk_Cpy_Ds.Ph1) = '000' Then '' Else '(' : Trim(Lnk_Cpy_Ds.Ph1): ') ' : ( handle phone 2) : ( handle phone 3 )