Search found 42189 matches

by chulett
Mon Sep 29, 2014 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Packed decimal to Varchar conversion issue
Replies: 6
Views: 3929

I wager 400 Quatloos that the terms "generic" and "RCP" come up in the reply. :wink:
by chulett
Mon Sep 29, 2014 9:29 am
Forum: General
Topic: syncbi.sh command not available
Replies: 3
Views: 1764

I had found this when poking around over the weekend but it does not specify where it can be found from what I saw. However, I would imagine a search would turn it up.
by chulett
Mon Sep 29, 2014 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Julian day
Replies: 3
Views: 2588

Yah, that too. :wink:
by chulett
Mon Sep 29, 2014 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE network connection on node
Replies: 6
Views: 5430

:!: You need to start your own posts rather than continue to jump on the end of unrelated topics. What version and O/S is this? I'm going to guess but you need to supply that information. Post the complete, unedited error message. Do an exact search of the forums here for it, the answer to your ques...
by chulett
Sun Sep 28, 2014 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trim function is not working
Replies: 2
Views: 2502

Re: trim function is not working

I am not able to trim the value from a char column. Sorry but... of course not, that's the nature of a CHAR field. Padding is automatic and controlled by the setting of your APT_STRING_PADCHAR environment variable. That "junk" is more than likely as ASCII NULL or hex zeroes, the default v...
by chulett
Fri Sep 26, 2014 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Loader Error
Replies: 1
Views: 1283

Re: SQL Loader Error

SyedAbrarAhmed.11 wrote:please see the loader logfile: //ds_scratch/node3/ora.20906230.0.31253.2.log for details.
Did you?
by chulett
Fri Sep 26, 2014 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling gp truncate
Replies: 2
Views: 1761

Ummm... thanks?

Not sure what else to say without a question posted along with it.
by chulett
Fri Sep 26, 2014 9:26 am
Forum: General
Topic: Failed to connect to Information Server Engine
Replies: 1
Views: 2275

Firewall? The ports it needs open are documented, check that they are all open and accessible to you. Start with the Planning, Installation and Configuration Guide found here.
by chulett
Fri Sep 26, 2014 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I've an issue in retrieval of data from sequential file
Replies: 4
Views: 1687

Or on a UNIX system use "od" (Octal Dump) to dump the file in various flavors to see what each character is. For example, od -h will dump it in hexadecimal.
by chulett
Thu Sep 25, 2014 12:47 pm
Forum: General
Topic: Control-M DataStage Plugin (Parameter Set Values)
Replies: 3
Views: 2191

Sounds like a support question for BMC.
by chulett
Thu Sep 25, 2014 12:45 pm
Forum: General
Topic: DSjob Logging all jobs within Sequencer
Replies: 4
Views: 1898

Re: DSjob Logging all jobs within Sequencer

I want to also log all the individual jobs inside the sequence job. Clarify for us exactly what this means. Do you just want to log a list of the jobs the Sequence job ran and perhaps their status? If so that's all in the Sequence job's log and as noted there are ways to get the "logdetails&qu...
by chulett
Thu Sep 25, 2014 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I've an issue in retrieval of data from sequential file
Replies: 4
Views: 1687

Then it's not a standard hyphen but probably one of those "smart" ones from something like Word. What is its ASCII value?
by chulett
Wed Sep 24, 2014 4:37 pm
Forum: General
Topic: Server Routine Name Pattern
Replies: 6
Views: 2102

Was wondering the same thing and waiting to see where the discussion went. Moved.
by chulett
Wed Sep 24, 2014 2:12 pm
Forum: General
Topic: log job details to log file from script
Replies: 8
Views: 2108

What happens if you add your login credentials to the command line?
by chulett
Wed Sep 24, 2014 1:48 pm
Forum: General
Topic: log job details to log file from script
Replies: 8
Views: 2108

What happens when you run the command yourself from the command line with all the bits filled in? Meaning - first get it working outside of your script and then fold it into the script with the bind variables.