Search found 15603 matches

by ArndW
Thu Jul 30, 2009 1:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error loading objects from list of rids
Replies: 1
Views: 787

I have done the same types of deployment with overwriting objects and have never seen this error message/warning. While it doesn't look like the message is affecting you, I would submit the problem to IBM via your support provider.
by ArndW
Thu Jul 30, 2009 1:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert Binary data to ascii format
Replies: 10
Views: 8646

While BASIC transform stages have ASCII and EBCDIC functions the better way to solve this splitting would be to edit your metadata or COBOL definitions to split the data before reading it, this would be a COBOL "REDEFINES".
by ArndW
Thu Jul 30, 2009 1:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable Create Copy or Save As Job
Replies: 11
Views: 7173

You can safely do a RESIZE of the DS_TEMPnnn, RT_CONFIGnnn and RT_STATUSnnn to static hashed files with a modulo of 1, this saves 3 subdirectories and 9 inodes per job.
by ArndW
Thu Jul 30, 2009 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to binary
Replies: 2
Views: 659

Column export will do it as well.
by ArndW
Thu Jul 30, 2009 12:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NVarchar to Varchar
Replies: 1
Views: 3065

Normally there is no need to explicitly convert in a transform stage. What are you doing to the value in teh transform that generates this message? What is your data source and what character set is it in?
by ArndW
Thu Jul 30, 2009 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where can i know the username who created the job?
Replies: 2
Views: 1416

The DS_AUDIT hashed file contains this information. This thread will get you on your way to using the DS_AUDIT hashed file.
by ArndW
Thu Jul 30, 2009 12:49 am
Forum: General
Topic: Converting hex to char
Replies: 14
Views: 4272

One can do it in PX, but not as easily. Take a look at this thread
by ArndW
Wed Jul 29, 2009 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while truncating data set
Replies: 5
Views: 4190

I would guess that the DataStage user has only "R" and not "RW" rights to "tmp//meas.ds" because of the error message
"Unable to open descriptor file to update: Permission denied "
by ArndW
Wed Jul 29, 2009 7:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading special characters from DB2 loading in Oracle
Replies: 3
Views: 2925

If you keep the same character set throughout there will be no problem with such characters. 1. What is the encoding used in your DB2 table? Have you told that to DataStage? 2. What is the encoding used in your Oracle table? Have you specified this in DataStage as well? When you fix #1 and #2 your d...
by ArndW
Wed Jul 29, 2009 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Character  converted to A
Replies: 7
Views: 3010

Debug it by checking the value of that string at each stage of the process to discover which component seems to be doing the modification.
by ArndW
Wed Jul 29, 2009 5:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning in transformer
Replies: 2
Views: 1525

I just tried using the search functionality and found 16 matches on the string "Input dataset 0 has a partitioning method other than entire specified; disabling memory sharing". Were none of those any help to you?

The first link I looked at had both a solution and explanation.
by ArndW
Wed Jul 29, 2009 4:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 6
Views: 4674

Does "View Data" function on both Oracle stages?
by ArndW
Wed Jul 29, 2009 4:57 am
Forum: General
Topic: understanding Rountine
Replies: 10
Views: 2141

The routine will read the first line of the file specified in "FileName" and return that string.
by ArndW
Wed Jul 29, 2009 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert Binary data to ascii format
Replies: 10
Views: 8646

There are numerous ways to do this. If you also have packed decimal data then the cmoplex flat file stage is best, otherwise just use a sequential file stage and specify that the data is EBCDIC in the format tab.
by ArndW
Wed Jul 29, 2009 4:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 6
Views: 4674

Re: Abnormal termination of DataStage

karry450 wrote:... DSP.Open at address 574...
What kind of stages are you opening?