DSXchange

Hello, I have a required where I need to assign the environment variable into local variable.. For e.g. Environment Variable $NM_USER=U1 $NM_USER1=U2 In Master Sequncer I have one variable USER. Based on the condition I want to read the value as USER=$NM_USER or USER=$NM_USER. The output should be E...

Thanks for the reply... As mentioned in my post, I am using RCP Job and have to pass the database credentials at run time..That is the reason we used parameterset. But due to process point of view, we have to either delete the patameterset or parameterize the parameterset... Design change in the job...

Hi, We have a RCP jobs which is connecting to multiple source systems. We have created the Parameterset in the job and the values are hardcoded(DSN,USER,PASSWORD etc). It has been decided to remove the hardcoded values from the parameterset. We tried few mentioned setps Defined the environment varia...

pandeesh wrote:Why a duplicate post?
One post is enough here to get your problem solved

\

I am sorry for duplicate post.

Can you please share the link where I can find the information.

Sorry,

It was a typo error

Just to elaborate

1-7 Week1
8-14 Week2
15-21 Week3
22-28 Week4
29-31 Week 5
32-60 2 Month
61-90 3 months



I hope I am clear..

Regards
Neeraj

Hello, I have requirement where I need to find the difference between 2 days and check if it Week1, Week2, Week3 , Week4 or month1 or Month2 Etc. I have calculated the difference by applying below mentioned function i..e. Number =DaysSinceFromDate(D1,'2010-01-01') My output should be as folows:- Num...

Hi,

It is running.. I am able to update the table.

Now what I am trying to do is to create a generic job where I will pass the table name and key columns.

Based on which the update statment can be paramterized?

like

Update #TableName#
set #TableName#.#Col1#='Test'


Has anyone done like that

Yes.. I am using this appraach as per my business requirement in the director, it looks like this #### STAGE: ODBC_Enterprise_4 ## Operator odbcwrite ## Operator options -db_cs [&DSProjectMapName] -data_source 'dev' -user 'test' -password '[&"DBPassword"]' -insertarraysize 2000 -ta...

Hi, Can you please let me know is it possible to update the record using Open Command option? I want to Update the record in the employee table using the command below:- Update Employee set Name='Gaurav' I know I can do it with user defined SQL which are available in ODBC/OCI Stages but I want to do...

Hi, While updating the record in Netezza database using Netezza stage in Datastage, we need to provide a temporary table which should be created by DBA or Datastage creates at runtime. My question is if I have a temporary table in different database insteat of having in the same database where I hav...

I found the solution.

By setting Allow Null Output=True.. I am getting the correct output.

Thanks
Neeraj

HI, I have a data Stud Subject1 Subject2 Subject 3 Subject4 a1 Null Null 10 Null a1 Null 5 Null Null a1 Null Null Null Null a1 Null Null Null Null I want an output like Stud Subject1 Subject2 Subject 3 Subject4 a1 Null 5 10 Null To acheive it, used an aggregate function,group by Stud and used Max fu...

HI, I need the help in getting the correct date. I have a weekly job and whatever date of the current week, i run my job, it extracts the data from previous sunday to Saturday. I want to put a constraint in datatstage to extract the data only from Saturday only. In Oracle, I have used the below ment...

Hi, I need to range lookup. As commincated by my colleage, range lookup doesn't work on string . it works for numeric field and for unknown reasons, a date or timestamp field is considered as string. So you need to transform your date or timestamps in a numeric field to get the correct results. So I...

HI, I have a requirement like... I want to convert my timestamp i.e. 2010-09-09 22:01:01 to a numeric field which I can use in my range look up. I had found some functions in oracle and DataStage to convert date into numeric field but I could not find anything for Timestamp. Is there any function av...