Search found 2288 matches

by roy
Tue May 31, 2011 7:18 am
Forum: General
Topic: about data stage8.5
Replies: 5
Views: 3274

There is no trial version you can practice on.
by roy
Thu May 26, 2011 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to base 64 (Base64) an ASCII string
Replies: 2
Views: 1998

for future needs

I've posted a Base64Decode executable export file in the FAQ forum
Hoping it will help someone in the future
Click here for the post
by roy
Wed May 25, 2011 8:45 am
Forum: General
Topic: Datastage Time Different from Server Time
Replies: 9
Views: 5897

Just since it was bumped... The director being a client side application, might be getting te settings from the client side, the same as your NLS setting when inporting a DSX file. So my guess would be setting your client with the same time zone as your server or the other way around. IHTH (I Hope T...
by roy
Sun May 22, 2011 3:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run time warning WARNING: DS0104-COBOL
Replies: 4
Views: 2178

It turns out that the table was built with 3 fields that were defined shorter then they really are.
Once this was found and corrected the warnings were gone :)

Thanks Ray!
by roy
Wed May 18, 2011 5:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run time warning WARNING: DS0104-COBOL
Replies: 4
Views: 2178

In other words, are you saying there is no other way except try and error; Ray? Not( :shock: ing)
by roy
Wed May 18, 2011 2:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run time warning WARNING: DS0104-COBOL
Replies: 4
Views: 2178

Run time warning WARNING: DS0104-COBOL

Hi All,
The warning I get from the MainFrame's run logs is:
WARNING: DS0104-COBOL A numeric data assignment caused an overflow;
Some numeric precision was lost.
Any ideas on how to get to the column in question?
I got quite a few of them ...

Thanks in advance ...
by roy
Thu Jan 20, 2011 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv(Col,"MC/N")
Replies: 2
Views: 1979

Roflmao :shock:
Was quick on the gun on my part
seems the programer ment to perform MC/N but instead used the MCA conversion sode :lol:
by roy
Thu Jan 20, 2011 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv(Col,"MC/N")
Replies: 2
Views: 1979

Iconv(Col,"MC/N")

Hi All, I'm experiancing an unexpected behaviour from the Iconv function when using te MC/N conversion code. The expected behaviur on my part is that it should work as documented, in my case preserving the space characters from the original string. For some strange reason the convrted string shows i...
by roy
Fri Jan 07, 2011 9:24 am
Forum: General
Topic: Can systems in HA configs be on two different O/S releases?
Replies: 4
Views: 2093

Hi,
:roll: :arrow: I wonder why you might want to do this in the first place :?:
by roy
Mon Mar 15, 2010 11:15 am
Forum: General
Topic: MVS 390, Char columns with complex data types
Replies: 7
Views: 2761

:arrow: :idea: So I think I failed to make cllear what was the solution we used :roll: So to complete the picture from my previous post ... We used Mainframe jobs to bring the data to Teradata work tables. that includes handling of all occurs/redefines and such interesting variants. Once the work ta...
by roy
Mon Mar 15, 2010 11:09 am
Forum: General
Topic: MVS 390, Char columns with complex data types
Replies: 7
Views: 2761

The string contains comp-3 elements that do not read well via db2 connect as a string. There is no logic for determining what kind of record were dealing with, perhaps since it seems only one kind of record is currently used. I eventually used a substr function in the sql to get the fields I need Th...
by roy
Tue Mar 09, 2010 11:44 am
Forum: General
Topic: MVS 390, Char columns with complex data types
Replies: 7
Views: 2761

My problem is that my source is a DB2 table :!: and correct me if I'm wrong DS only reads CFF files, it can't create them :cry: adding the fact I was told they won't build me a "normal" file I can read representing a sain version of the data I'm stuck with 3 people to help me named: MMI (M...
by roy
Tue Mar 09, 2010 4:11 am
Forum: General
Topic: Information on the files in &PH&
Replies: 4
Views: 2465

Hi, In addition to the above said In any case that your job crashes with little to no reason in the logs, reset that job using the DS Director and if there is any information in the &PH& job's-run log it will pop up as a "from previous run(...)" log entry in one or more of the rese...
by roy
Tue Mar 09, 2010 4:02 am
Forum: General
Topic: how much volume of data can load in Xml stage per file?
Replies: 3
Views: 1489

Hi, In my experiance and as Ray said if your DS Server has enough resources when the job runs , everything around 200MB (+-) starts to be slow and 1GB(+-) might fail or take a very long time to finish. I think that till IBM decides to improove the XML Plugin we might concider an alternative to using...
by roy
Tue Mar 09, 2010 3:53 am
Forum: General
Topic: MVS 390, Char columns with complex data types
Replies: 7
Views: 2761

MVS 390, Char columns with complex data types

Hi All, :arrow: This is a MVS / 390 Related Topic :!: I'm facing a case where there are db2 table fields of type char(x) that holds an array of records (by occurrs) or a records with redefines. The redifines are less of an issue since only one type of record is relevant. The problem is that in those...