Search found 4992 matches

by kcbland
Tue Oct 25, 2005 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Truncating last char in insert to varchar field in MS SQL
Replies: 12
Views: 3351

What are your exact stages in the design?
by kcbland
Tue Oct 25, 2005 2:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of environment variables
Replies: 13
Views: 4402

Ahhhh, somehow I feel I walked into that one. So the posters answer is that the listed variables are something they dreamed up. However, the vanilla variables that come with the product are available in Administrator. There are also the environment variables available for the DS Engine under the dse...
by kcbland
Tue Oct 25, 2005 2:09 pm
Forum: Site/Forum
Topic: Write a Book!
Replies: 40
Views: 20404

rwierdsm wrote:Seems a little odd to me.


Yep.
by kcbland
Tue Oct 25, 2005 2:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of environment variables
Replies: 13
Views: 4402

ray.wurlod wrote:They are visible in the Administrator client.


Now, my eyes are tired, but are they that tired that they didn't see:
Vuser
DSJobName


listed under the environment tab? The post is for Server, but even checking in the Parallel tab didn't yield results. Help out these tired eyes....
by kcbland
Tue Oct 25, 2005 12:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add_to_heap() - Unable to allocate memory
Replies: 6
Views: 1406

Use the Search facility. Paste "add_to_heap" in the box and select exact match. You can read a lot of discussion about this error. Short story, either ran out of write cache, or ran out of disk space.

Since you upgraded, perhaps your project default write/read cache settings are now different.
by kcbland
Tue Oct 25, 2005 11:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while viewing data
Replies: 19
Views: 4595

That's two in a row. I'm at a loss how to proceed other than to say it's pretty simple. Maybe it's time to call tech support.
by kcbland
Tue Oct 25, 2005 11:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of environment variables
Replies: 13
Views: 4402

I don't know where vuser applies to DS Server, is this a variable that applies to one of the other tools? As for DSJobName, I wasn't aware that was being pushed into the environment of a job.

Anyone else want to pick this one up because I'm at a loss.
by kcbland
Tue Oct 25, 2005 11:10 am
Forum: Site/Forum
Topic: Write a Book!
Replies: 40
Views: 20404

Yeah, it's hard to write a book about a GUI code generator when you're prevented from showing screenshots of said GUI.
by kcbland
Tue Oct 25, 2005 10:15 am
Forum: Site/Forum
Topic: Write a Book!
Replies: 40
Views: 20404

As with myself, you end up writing about 10 different versions, each absolutely applicable to the customer site on which the tool was deployed. Ultimately, you cannibalize each document for each engagement. You also then write a bunch of little white papers describing hash file usage, SCDs, etc. The...
by kcbland
Tue Oct 25, 2005 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while viewing data
Replies: 19
Views: 4595

To repeat: When you setup the OCI (Enterprise) stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
by kcbland
Tue Oct 25, 2005 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: header and footer
Replies: 7
Views: 4077

Write a shell script to get a line count (wc -l) of the file, then issue a head -n(?-1) yourfile|tail -n(?-2) where ? is the result of the wc -l. Use this korn shell script as a filter on the file in the sequential stage. Tuck this shell script away somewhere and reuse whenever necessary.
by kcbland
Tue Oct 25, 2005 9:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding date conversion into dd/mm/yyyy
Replies: 8
Views: 2126

Welcome aboard. What is your target stage? Is it ODBC, OCI, etc? What database and version. Can you tell us the datatype of the column in question? "No data in target" means no rows, or empty columns? Are there any messages in the job log?
by kcbland
Tue Oct 25, 2005 8:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of environment variables
Replies: 13
Views: 4402

What are you trying to do? What do you think you will find? Write a simply Sequence job with a command stage to execute "env" and you'll see the environment a job.
by kcbland
Tue Oct 25, 2005 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage job return code(Real urgent friends)
Replies: 6
Views: 3705

Really? I tried

dsjob return code


in the Search facility, selected match all words, and got a wealth of information.
by kcbland
Tue Oct 25, 2005 8:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File
Replies: 11
Views: 2244

Okay, but you do realize any existing "." will also be removed?