Search found 42189 matches

by chulett
Fri Apr 20, 2012 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Schema file error
Replies: 10
Views: 4315

I'm assuming he means something like this: record {delim=';',final_delim= none} ( DFCPRO:nullable STRING[7] {width=7, null_field=''}; MTMNVR:nullable DECIMAL[5,0] {width=5, null_field=''}; MTMXVR:nullable DECIMAL [6,0] {width=6, null_field=''} ) Why not setup some metadata like the above and then te...
by chulett
Fri Apr 20, 2012 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connect to Vertica Database
Replies: 5
Views: 4499

Never have (never even heard of it) but dollars to doughnuts you'd need to use ODBC for that. And you'd need to purchase the drivers as well, I would imagine. Hmmm... perhaps not, from their website: Vertica offers this industry-standard connectivity through ODBC, JDBC, ADO.Net and our rich API as w...
by chulett
Fri Apr 20, 2012 6:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between the design
Replies: 4
Views: 1346

I would wager someone could, yes. One has four stages, the other has five. :D

Is this a test? Trick question? :wink:
by chulett
Fri Apr 20, 2012 6:34 am
Forum: General
Topic: diffguicomparer
Replies: 4
Views: 2342

What happened when you tried, Phil?
by chulett
Thu Apr 19, 2012 11:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading TEXT from SYBASE into CLOB in ORACLE
Replies: 15
Views: 5761

Huh... good to know.
by chulett
Thu Apr 19, 2012 10:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Single charcter match along with LIKE
Replies: 10
Views: 2363

Seems you'd need to fall back to the Matches function for that, which would mean a Server job or a Server Shared Container.
by chulett
Thu Apr 19, 2012 8:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get first or nth character from a string?
Replies: 9
Views: 11778

You got the gist but there's no real need to do it in two steps.
by chulett
Thu Apr 19, 2012 5:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Single charcter match along with LIKE
Replies: 10
Views: 2363

Can you be more specific regarding what you mean by "where _ represents a single character"? I'm unclear what the requirement is or what the underscore represents here... it must be a character rather than a number? :? Typically when you want to do "like xxx%", meaning the string...
by chulett
Thu Apr 19, 2012 4:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading TEXT from SYBASE into CLOB in ORACLE
Replies: 15
Views: 5761

Wasn't sure, hence my reply... what release were they added?
by chulett
Thu Apr 19, 2012 4:58 pm
Forum: General
Topic: $DSHOME/bin not part of dsenv file
Replies: 4
Views: 2961

Well, there you go. :wink:
by chulett
Thu Apr 19, 2012 4:55 pm
Forum: General
Topic: dscompinst: cannot execute binary file
Replies: 6
Views: 4121

Contact support.
by chulett
Thu Apr 19, 2012 11:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File Stage
Replies: 27
Views: 10509

No I din't given 01. I don't know where to give that 01 level number. If I give at column definition it is throwing only 02 to 49 can be defined. Still doesn't answer my question, I'm afraid. Did "they" give you a file that contains the COBOL metadata, the FD? You'll need that to import e...
by chulett
Thu Apr 19, 2012 7:38 am
Forum: General
Topic: log files not releasing space
Replies: 12
Views: 6349

Yes, that would be correct.

And a "Purge" from the Director should release the space in the log from what I recall. That or a CLEAR.FILE on the RT_LOGnnn hashed file itself but then after using that you'd need to re-establish any auto-purge settings.
by chulett
Thu Apr 19, 2012 6:43 am
Forum: General
Topic: log files not releasing space
Replies: 12
Views: 6349

ray.wurlod wrote:Hashed files do not release space unless they are resized.
Or cleared.
by chulett
Thu Apr 19, 2012 5:49 am
Forum: General
Topic: Datastage App using API
Replies: 7
Views: 9823

I seem to recall our Kim Duke built a tool for web-based monitoring, wonder if he's kept it up to date? Ah, check here for DSWebMon. Tested up through version 7 it would seem...