Search found 42189 matches

by chulett
Fri Aug 27, 2010 9:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: extra commas in SEQ file
Replies: 3
Views: 1800

Something you didn't post an example of? Yes, those would be a problem.
by chulett
Fri Aug 27, 2010 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: extra commas in SEQ file
Replies: 3
Views: 1800

The comma inside the quoted string should not be a problem. Are you certain you told it you had double-quotes for the quote delimiter?
by chulett
Fri Aug 27, 2010 6:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I copy hash files from UNIX command line?
Replies: 8
Views: 4659

I typically tar or zip up all of the appropriate files, transfer the archive to the new server and then unzip/untar them over there.
by chulett
Fri Aug 27, 2010 6:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel jobs has status = running but actually not running
Replies: 8
Views: 3541

Do an exact search here for "jobmonapp".

:idea: And please, if you are going to use BBCode and Smilies for quoting tags and happy faces and the like, you cannot disable them in your posts. Change your default. I 'fixed' your posts in this thread.
by chulett
Fri Aug 27, 2010 6:35 am
Forum: General
Topic: warning while running the sequence (/bcpsetenv.ksh:)
Replies: 2
Views: 1188

I'll wager it's simply an artifact of the "automatically handle" option and the fact that the routine does not return a zero. As noted, post the complete, unedited error and we'll see.
by chulett
Thu Aug 26, 2010 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get timestamp with microsecond
Replies: 6
Views: 3977

You may need to upgrade or roll you own. Also, Mike has already mentioned this but so has Arnd in the past:
ArndW wrote:You will need to declare your Timestamp column with the extended attribute of "microseconds" in order to store fraction seconds.
Have you enabled that attribute?
by chulett
Thu Aug 26, 2010 7:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to achieve the output from DS8.1
Replies: 5
Views: 1848

In other words, spell out your requirements in words for us, just like someone must have spelled it out for you.
by chulett
Thu Aug 26, 2010 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Array Size Property of Oracle Connector Stage
Replies: 6
Views: 10140

You may be confusing Array Size with Transaction Size. The former does not allow a zero while the latter is the one that does. Can you quote the docs where you found it said zero was allowed?
by chulett
Thu Aug 26, 2010 5:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: warnings while loading data in to fixed width file
Replies: 1
Views: 1255

Your data is too large for the target column, perhaps a trim or a substring is in order?
by chulett
Thu Aug 26, 2010 5:45 am
Forum: General
Topic: Issues when installing IIS 8.1 on SUSE 10 SP1
Replies: 4
Views: 1997

I am trying to install IIS 8.1 using InfoSvr_v8.1_SUSE_x86.tar.gz downloaded from IBM on SUSE 10 SP1 32 bit. Everything is fine until Database for metadata connection screen (I am using Oracle 10g on a different server) I am getting a screen where it is asking for existing WAS installation path. We...
by chulett
Thu Aug 26, 2010 5:44 am
Forum: General
Topic: Please HELP.. Cannot install IIS 8.1 on SUSE 10 SP1 32 bit.
Replies: 1
Views: 1171

:!: Please don't post the same question twice, especially to put the extra one in the wrong forum. You've already got a perfectly good conversation going on this problem here and if you feel the need to expand on it, please do so over there. As an added bonus, I'm going to move your additional comme...
by chulett
Thu Aug 26, 2010 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get timestamp with microsecond
Replies: 6
Views: 3977

What operating system? An exact search for "microsecond" should turn up other conversations on this topic, including (from what I recall) the operating systems where this does or does not work.
by chulett
Thu Aug 26, 2010 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML node aggregation
Replies: 6
Views: 2707

... or they could just "play with the key" as Ernie posted. He's really smart and I would take his XML advice in a heartbeat... and have. :wink:
by chulett
Thu Aug 26, 2010 5:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cleaning duplicate's
Replies: 2
Views: 1257

Or you can bring your data in in sorted order, sorted on the column(s) to check for duplicates, and use stage variables in a Transformer to do what is known as 'group change detection'. Every time you see a combination of fields from your 'duplicate' columns, let the first one through and constrain ...
by chulett
Thu Aug 26, 2010 5:26 am
Forum: General
Topic: Datastage version for 64-bit windows?
Replies: 3
Views: 3059

As with most 64bit operating systems, 64bit Windows will happily run 32bit applications.