DSXchange

FYI

With Hash File, the lookup is happening in TFM...The space was removed in the design in my design (I didnt expect).. So it looks like hash file is feeding feed file.

Hi We are migrating our jobs from DataStage 7.5 to 7.5.2 server edition. When I run a particular job in both of the versions (With 50 Warning limit) , it is behaving differently... The job is loading the data from a feed file to oracle table using OraOci Bulk stage. HashFile | v File ->Tfm->OraOciBu...

Hi

Can you please give me the format code in IConv to recognize YYYYMMDD
(Integer)
Eg: To recognize 20071118, What to put in IConv format code?

Thanks
Sai

Hi I just found that NLS button in administrator is enabled in new DS Server 7.5.2. Where as it is disabled in our previous DS server 7.5. Taken that NLS is installed in my new machine, To make IConv to work, What should I need to do. I mean, To get correct ouput from IConv for 20071118, What exactl...

I just want to have confirmation,Is this behaviour because of NLS installation?

I dont know whether NLS is installed on my DS Server 7.5.2 or not, May I know, The way to check that.

I just want to have confirmation,Is this behaviour because of NLS installation?

I dont know whether NLS is installed on my DS Server 7.5.2 or not, May I know, The way to check that.

The output in DS 7.5 for the following function is

IConv(20071118,"D")

Output:
14567


In DS 7.5.2 For the same function
IConv(20071118,"D")

Output :
-310248

Please let me know the solution.

Thanks
Sai

Hi I am using IConv to find out the difference between two dates (i.e Date1 and Date2) in terms of days, as follows: IConv(Date2,"D")-IConv(Date1,"D") The format of dates in 7.5 are as follows: Date1 format YYYYMMDD (Integer datatype) Date2 format "MM-DD-YYYY" (char dat...

Hi I have a sequencer A calling upd_dim_msgr_d job. The jobs are scheduled. Today I ran the job and it is giving the following error: 03:08:34: Exception raised: @upd_dim_msgr_d, Error calling DSRunJob(upd_dim_msgr_d), code=-99 [General repository interface 'other error'] I am not able to identify t...

Hi Chullet I tried experimenting changing all the combinations : double to decimal and integer to decimal The job is working when I change for a particular column from Integer(10) to decimal(10), All the other columns remained same. Decimal(10) means, will it hold 9 10 digits at max? i.e. 9999999999...

Hi

I would like to know the exact meaning of update rows or insert rows update action in Oracle database stage.

I am expecting this as a merge statement in oracle, if a match is found with the key columns then update else insert....

May I know whether I am correct or not.

Thanks
Sai

There are around 15 columns,

The data types in DS job transformer are as follows:

Integer (10)
Double (15)

The data types in Oralce are as follows

Either Number (for Double(15) columns specified in DS)
or Number(10) (for Integer(10) columns specified in DS)

Thanks
Sai

Hi I have a job which does direct select from a table from a dblink and insert to another table in local db. the design is as follows OracleDb stage -> Transformer ->OracleDbStage In XFM, Direct one to one mapping is happening. This job is scheduled daily, Today it ran the job and aborted with the f...

Thnaks ArndW

May I know the information regarding these metadata tables,
specifically is there any documentation available to see what the list of tables available ?


Thanks
Sai

Hi Can any one tell me about how do we connect to DataStage from command prompt and issue these DataStage SQL's. I tried using uvsh and dssh in /DSEngine/bin, but the following commands didnt work.. Can you pls help me on this. Thanks i. select * from ds_jobs ii. select * from ds_jobobjects Thanks Sai