Search found 42189 matches

by chulett
Wed Feb 01, 2017 10:25 pm
Forum: General
Topic: Sequence and User Variable Activity stage during restart
Replies: 8
Views: 3586

JPalatianos wrote:I also noticed that the UVA stage does not have a checkbox for 'Do not checkpoint' property.
Was wondering about that... gonna have to defer to others on this one.
by chulett
Wed Feb 01, 2017 5:01 pm
Forum: General
Topic: Sequence and User Variable Activity stage during restart
Replies: 8
Views: 3586

I'm not aware of any special 'restart rules' for the UVA stage so I assume it follows all of the normal rules. Meaning, once it has been 'checkpointed' it will not run on restart and you would override that behavior by enabling the 'Do not checkpoint' property. But it's been quite a while and things...
by chulett
Tue Jan 31, 2017 5:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UTF-8 XML not showing up as expected
Replies: 0
Views: 1568

When you say "the message" are you still talking about the contents of XML file you've created? And by "picked up" you mean the file is read from the server or is it consumed in some other fashion?
by chulett
Mon Jan 30, 2017 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UTC to AEST
Replies: 8
Views: 4148

Yes, the fact that I copied the wrong function name as you're obviously not dealing with a date. :wink:

Oddly enough, the correct one would be:

TimestampOffsetByComponents()
by chulett
Mon Jan 30, 2017 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Identify Invalid Dates
Replies: 2
Views: 1633

Don't use "IsValidDate" to check the string, use "IsValid" with a data type of "Date" instead.
by chulett
Mon Jan 30, 2017 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UTC to AEST
Replies: 8
Views: 4148

AEST as in Australian Eastern Standard Time? And you are already looking up a number of hours you need to add to the timestamp?

DateOffsetByComponents()
by chulett
Sun Jan 29, 2017 11:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenating rows into a column
Replies: 2
Views: 1406

I've split your issue out into it's own post so you have control over its fate, and linked you back to the other post. Since you have no history here, I also had to guess at your particulars. If you aren't using an 11.x version or UNIX, please edit your post to correct that. As to your issue, can yo...
by chulett
Thu Jan 26, 2017 7:22 am
Forum: General
Topic: DataStage turns 20!
Replies: 6
Views: 2431

Forgot about that... I have a nice long-sleeve Ardent shirt as well. Still have the original VMark manuals we got, too. 8)
by chulett
Wed Jan 25, 2017 4:45 pm
Forum: General
Topic: DataStage turns 20!
Replies: 6
Views: 2431

Damn.... same here. 3.0 in either 1998 or 1999. Would have to dig out the clay tablet my resume is on to check.
by chulett
Wed Jan 25, 2017 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

Have you involved your official support provider yet? Anyone else want to chime in? I'm at my limit of helpfulness, it would seem. Those charactersets seem fine to me so thinking it will come down to why the Java in your CONNX software can't handle the data. Seems to me it be useful to loop them in ...
by chulett
Wed Jan 25, 2017 1:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

ep_datastage wrote:how do i attach a screen shot
You upload it to one of the plethora of free file hosting sites (one example, http://imgur.com/) and then use URL tags to get it added to your post. They will automatically generate them for you. Or worst case just post the URL and people can click on it.
by chulett
Wed Jan 25, 2017 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

Okay... random thought on the drive in to work... HOW are you reading / getting the data from the C-ISAM "table"? From what I recall, those are represented by two files - one .dat and one .idx that make up what can be treated as a table. Are you reading the .dat file directly somehow? Or h...
by chulett
Wed Jan 25, 2017 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

FYI since you are new here. There's no need to quote everything all the time, even if the 'Reply with quote' is very conveniently located right over <points up and to the right> there. Please use the Reply to topic link that's at the top and bottom of every page, that will save me the cleanup effort...
by chulett
Tue Jan 24, 2017 6:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

Okay, fair enough... can you post the actual failure error(s)? Unedited, please.
by chulett
Tue Jan 24, 2017 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trying to load POSTGRES table with data from C-ISAM table
Replies: 15
Views: 6793

Hmmm... it would be best if you could find a way to get a hex or octal dump of the file so we (or you) can determine the values at play here. Clarify this for me - are you looking for a way to load them into your target as-is or are you looking for a way to strip them from the data before you load it?