DSXchange

Source is Decimal 20.3 target Decimal 17.3

How to map MSD from souce to target
e.g

The source field value is 12345678901234567890.123

then the target field value will be 12345678901234567.123

Any Idea appreciated

When I am running job using Control M (dsjob command)

1) The process I am able to see at Unix level

ps -ef |grep jobName

process is running

2) But the status is not reflecting in DataStage Director

What is the possble reason


Please suggess

How tio Find no of Projects on the DataStage server

is there any Hash table containg , which hold the Project information.

like : DS_JOBS CONTAINS JOBS INFORMATION

1) MY job is having lookup first lookup with conditon(isnotnull(x ) and isnotnull(y)) --continue and looup is reject ref | | ds---------lkp-------output when I am replcing the above datastage job with DB2 Query where fields src ref x (nullable yes) x (nullable yes) x (nullable yes) y (nullable yes) ...

Dear All 1) Is there any way to know, my DataStage PX server at which patch. 2) Where do I find the patch# 97193 I need the patch# 97193 because I wan't to avoid the following error in my log Primary Error: sqlcode=100, state=02000, message=[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for ...

Yes. The dsjob command has a -report option. ... Hi Ray Thanks for your reply But using this command dsjob -report Projec_dev job we only able to get the following details STATUS REPORT FOR JOB: job Generated: 2008-06-12 00:30:18 Job start time=2008-06-12 00:28:31 Job end time=2008-06-12 00:28:33 J...

Is it possible to get the

DataStage Desinger-->File -->Generate Report

using Unix comman line (Example run job using dsjob command)

Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as ... Thanx for your prompt reply Where exactly The default values are stored within the "job me...

Hi folks,

Where the job parameters pertaining to a job are stored in the datastage universe.
e.g. all the job names stored in table DS_JOBS.

In Transformer Stage following the constraint not working Properly Here x is varchar y, z, zz are decimal Constraint (x <> "ZZZB" And ) ( ((IsNotNull(Y)) AND (Y<>0)) Or ((IsNotNull(z)) AND (z<>0)) Or ((zz)) AND (zz<>0)) ) But Working in Filter Stage Condition (x<>'ZZZB' AND ( ((Y Is Not Nu...

Which table of DataStage Repository contain Orchestrate schema file

how to find it through uvsh prompt

chulett wrote:Try sliding your Columns over to the right and setting the last field's Incomplete column attribute to Replace. ...

please let me know how you will slide through datastage

ray.wurlod wrote:Your requirement is not clear. Your words and your example do not match.

Please document the algorithm by which 1 generates 1,2; 2 generates 3,4; 3 generates 4,6 (note that 4 is repeated); 4 gener ...

Please check the currected

Dear Gurus please guid me on the following source ----- - ------- Target Cust Id ----- -------- Cust Id1 ,Cust Id2 1 ---------------------- 1 , 2 2 ----------------------3 , 4 3 ---------XFM ------- 5 , 6 4 ---------------------- 7, Null 5 6 7 I have above source table with different cust Id , I wan...

Dear Gurus 1>my source system use to send flat files(around 100) 58 column with FIXED WIDTH delimited now they are added one more column 59 some files having column having 58 columns and some 59 when I am trying to process at tranformation with 59 columns(meta data)it is creating problem as follows ...