Search found 42189 matches

by chulett
Fri Jun 15, 2012 8:35 am
Forum: General
Topic: LISTAGG Function in ORACLE 11g R2
Replies: 5
Views: 3670

Nice. :wink:
by chulett
Fri Jun 15, 2012 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LinkRowCount is coming as '0' in dataset stage
Replies: 2
Views: 1379

We have, right here and just yesterday.
by chulett
Fri Jun 15, 2012 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Access Violation (Datastage 8.7)
Replies: 2
Views: 2297

Thank you for posting this.

I'm curious if they included an explanation of how that fixes anything or what exactly it does when set to true...
by chulett
Fri Jun 15, 2012 6:41 am
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

I have executed .\dssh in DSEngine directory.. while executing :UPDATE SDKSequences USING DICT VOC SET F1 = '192' WHERE @ID = 'E_OPER_UNIT_TBL' got error: DataStage/SQL: table sdksequence doesn't exist. As stated before, if you launch from DSEngine you must LOGTO the Project you want to work with f...
by chulett
Thu Jun 14, 2012 10:56 pm
Forum: General
Topic: C++ compilers
Replies: 3
Views: 1908

They've been posted here before and a search should turn them up. One example is here. Hopefully the links are still valid.
by chulett
Thu Jun 14, 2012 10:51 pm
Forum: General
Topic: Need to run a Seq withinn another
Replies: 9
Views: 3303

Script the report generation and save the output to a tmp file. Collect the information you need for each column via standard UNIX functions like grep and cut. You can then echo them out with your delimiter of choice to a flat file.
by chulett
Thu Jun 14, 2012 9:27 pm
Forum: General
Topic: Is Server Edition supported by Win 7 ?
Replies: 5
Views: 1782

You could install the client.
by chulett
Thu Jun 14, 2012 8:52 pm
Forum: General
Topic: Is Server Edition supported by Win 7 ?
Replies: 5
Views: 1782

Windows 7 XP Mode.

Keep in mind the fact that for 7.x the Client is supported on Windows XP and the Server on Windows Server 2003 or a flavor of UNIX.
by chulett
Thu Jun 14, 2012 8:33 pm
Forum: General
Topic: Is Server Edition supported by Win 7 ?
Replies: 5
Views: 1782

Neither the client nor the server side of the 7.x product are supported on Windows 7.
by chulett
Thu Jun 14, 2012 5:55 pm
Forum: General
Topic: Can DataStage search for a Pattern of Files in Sub-Direcotor
Replies: 10
Views: 4304

Since we're talking XML consumption here, I'm assuming the goal is to collect the various filenames so the file path can be passed to an XML Input stage where it will do the actual reading of the contents. Yes, no, maybe so? If that's the case then off the top of my head I'd say perhaps a "find...
by chulett
Thu Jun 14, 2012 5:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: concatenation of four column into a single column
Replies: 7
Views: 2121

Of course, just offering an alternative. Perhaps an EmptyToNull() wrapper around the whole thing? :wink:
by chulett
Thu Jun 14, 2012 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: concatenation of four column into a single column
Replies: 7
Views: 2121

... unless you want the result to be an empty string in that case. If so, stick with just the "else" portion. :wink:
by chulett
Thu Jun 14, 2012 4:55 pm
Forum: General
Topic: how to callback to DS to get its Recent job ouput
Replies: 5
Views: 2239

And you'll need to leverage the various "DSGet" functions, depending on exactly what you need to do. Speaking of which, can you expand a teeny bit on what "output its log" means? For example - outputs in what format, to where? To what purpose?
by chulett
Thu Jun 14, 2012 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: concatenation of four column into a single column
Replies: 7
Views: 2121

Define 'not working'. It is a perfectly valid function in the 7.x version of the product, one that I made extensive use of back in the day, doing exactly the kind of things you've asked about here.
by chulett
Thu Jun 14, 2012 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Count issue
Replies: 4
Views: 1733

From what we've seen here over the years it is a known "issue" with datasets, kind of surprised it is still an issue. I would think it would be worth asking your official support provider about.