Search found 42189 matches

by chulett
Mon Feb 08, 2016 11:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to timestamp
Replies: 10
Views: 4506

I just meant the bit after the last colon were the milliseconds... but yes, let's not say what we're thinking it is - get all of us some clarification. :wink: And just want to re-emphasis the fact that the data you are showing us is not a timestamp, that would require a full date and time component....
by chulett
Mon Feb 08, 2016 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to timestamp
Replies: 10
Views: 4506

Suggest you read my reply that you probably just missed. :wink:
by chulett
Mon Feb 08, 2016 10:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to timestamp
Replies: 10
Views: 4506

We got that. 99999999 - 83885269 =16114730 However, as Ray noted, that is not a timestamp. Time perhaps or a duration, but timestamp no. What do you need to do with it, where / how will it be stored? Guessing when you show it as "16:11:4730" that means minutes, seconds and milliseconds? Pl...
by chulett
Mon Feb 08, 2016 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file: spaces between two characters in all fields
Replies: 6
Views: 3141

This hex 00, is that what was between all of the characters? If so, you need to thank whomever sent that to you for the wonderful puzzle. :roll:

:wink:
by chulett
Fri Feb 05, 2016 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file: spaces between two characters in all fields
Replies: 6
Views: 3141

You see them that way where exactly? If it is having an issue reading / parsing the file it can show you the 'raw' data and it does that with spaces between everything inside curly braces like so:

{O r d e r R e a d y F o r P i c k u p _ E N _ Q A B o u n c e d}

Is that what you are seeing?
by chulett
Fri Feb 05, 2016 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Enterprise - PATH search failure odbcread
Replies: 3
Views: 2689

I'm sure it will, thanks for posting your resolution. :)
by chulett
Fri Feb 05, 2016 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservices Client - Error
Replies: 19
Views: 3689

:!:

Naren, please stop quoting everything all the time when you post. Do it when it makes sense but not all the dang time. Use the Reply to topic link rather than Reply with quote, saves me having to clean up constantly. Thanks.
by chulett
Fri Feb 05, 2016 8:04 am
Forum: General
Topic: Get all child status recursively
Replies: 11
Views: 4632

Care to post it for the greater good? :wink:
by chulett
Thu Feb 04, 2016 8:50 am
Forum: General
Topic: DSODB queries
Replies: 8
Views: 7674

So... use your query tool of choice for this, i.e. Toad as one popular example.
by chulett
Wed Feb 03, 2016 4:48 pm
Forum: General
Topic: dsjobreport argument
Replies: 4
Views: 2756

Are you asking the 2008 poster or the 2016 commenter? I think the latter just literally did a drive-by eight years later to let us know that it works now with or without the trailing slash. :wink:
by chulett
Wed Feb 03, 2016 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Needed in calling DB2 Stored Procedure
Replies: 8
Views: 3180

Engage your official support provider, if you haven't already. They should be perfectly happy to give you whatever help / explanation you need. This is part of the support your company pays for.
by chulett
Wed Feb 03, 2016 8:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate schema files in datastage
Replies: 11
Views: 7477

... along with RCP but as noted it really depends on what you need to do after you read the file. What's your target, by the way?
by chulett
Tue Feb 02, 2016 4:18 pm
Forum: General
Topic: Operations Console Errors
Replies: 2
Views: 1214

Since this is your first post, I had no idea how to set your particulars: OS & Version specifically. I guessed but if they need to be adjusted, please edit your post and correct them.

Thanks!