Search found 42189 matches

by chulett
Wed May 02, 2007 6:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 4457

So... you're just making these sizes up? :?

Kumar has already answered your question as asked. Ray has attempted to bring some sanity to it.
by chulett
Wed May 02, 2007 6:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Transform function
Replies: 3
Views: 694

Make sure you come back and ask questions if there's something in there you don't understand...
by chulett
Wed May 02, 2007 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Updating UV_USERS - will this work?
Replies: 5
Views: 3412

Unfortunately there is no system backup because against advice no backups were taken as it was deemed quicker to perform reinstall than get a system restore. I think the decision was based on the perceived service provided by the company that looks after the servers (no names but they also make sau...
by chulett
Tue May 01, 2007 11:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Transform function
Replies: 3
Views: 694

Find it in the Manager and double-click on it. The Long Description and all 'source' code will be revealed.
by chulett
Tue May 01, 2007 9:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: teraread error in Datastage
Replies: 5
Views: 5197

:lol: In other words, talk to your SAs and/or Network guys.
by chulett
Tue May 01, 2007 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Creation in a different location
Replies: 7
Views: 1669

From doing a quick test the difference between a hashed file using the account and one using dir path is an additional line Directory "/mydir/" It should be parameterized and I assume the parameter won't exist in any of the jobs yet. Keep that in mind as a need for this procedure. Hmmm... a rouge p...
by chulett
Tue May 01, 2007 9:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Creation in a different location
Replies: 7
Views: 1669

I haven't had to do this, but if I did this is the approach I would take: Export a single job that uses an account based hashed file. Change one hashed file stage to be pathed with your parameter of choice. Export the changed job. Examine the differences. From that, determine the feasibility and lev...
by chulett
Tue May 01, 2007 12:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder Stage
Replies: 8
Views: 2222

And you really can't just concatenate the files together for processing all at once in a single file? That is so much easier to setup. :wink:

Unfortunately, I don't have the time to lay it all out right now. Perhaps tonight. Perhaps someone else would be willing to?
by chulett
Tue May 01, 2007 11:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder Stage
Replies: 8
Views: 2222

I'm sorry but I don't follow your question. Are you asking about the Folder stage, or the User Variables Activity stage or something else? Please explain the approach you decided to try and what exactly it is you are trying to accomplish. Concatenation? That is easy to setup. Looping in a Sequence j...
by chulett
Tue May 01, 2007 7:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to stop running job
Replies: 8
Views: 2663

Either it is being monitored or it is in fact still running. You need to determine which.
by chulett
Tue May 01, 2007 6:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the length for decimal field
Replies: 17
Views: 5511

Hi "soma_june",

You can find it here, two posts up from the last post. :wink:
by chulett
Tue May 01, 2007 6:51 am
Forum: General
Topic: Job disappeared after migrating with Version Control
Replies: 4
Views: 1714

Welcome! Known 'parasite' bug with Version Control. The job exists - it is just no longer in the catorgory it should be and, when you find and open it, you'll find the contents are another job entirely. Open it from VC to verify the presense of the parasite. Find out where it ended up with the follo...
by chulett
Tue May 01, 2007 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing tabs from a column
Replies: 2
Views: 999

A hex editor or perhaps 'od' - an Octal Dump of the file. There should be a 'show hex' switch if you're more comfortable with that. Tell us what you find.
by chulett
Tue May 01, 2007 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error updating As400 table in ODBC stage
Replies: 2
Views: 981

Re: Error updating As400 table in ODBC stage

In UAT an ODBC stage is giving an error as follows (I can see from the logs that the same error was generated before migration as well but the problem is that for the same job it is not giving the error on production which is currently running on 7.1.) That would imply a difference in the offending...
by chulett
Tue May 01, 2007 6:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the length for decimal field
Replies: 17
Views: 5511

And for goodness sakes, if you are going to keep going back and forth on this, post some actual data samples you are seeing. Made up stuff like "I am seeing 1234567891234.00" doesn't help anyone help properly.