DSXchange

Hello I have a requirement where i need to abort the job based on some source column value. I am reading a sequential File and There is a lookup involved in between. Based on the Source value which iam reading from the sequentila file i am doing the lookup to get the REJCOUNT value from the Lookup F...

Thanks ray for your information,
Just a quick question

Can i pass parameter value like below line?

errcode = DSSetParam(hJob2, "$DBNAME",$DBNAME)
Correct me if anything was wrong.

Thanks for your quick reply. Can you please clarify me on the below piece of code . I used the DBNAME,DBUSER as an environmental varibles in the batch job and set default value as $PROJDEF .And i want to pass those values to the calling job errcode = DSSetParam(hJob2, "$DBNAME",$DBNAME) er...

Hi all, I need some help regarding calling a job from job control code . Iam having one job Test_Job which takes data from oracle table and load's into the sequentail file. And DSNAME, DSUSER are environmental variables. And the job ran fine. But when i tried to call from job control i got some fata...

My base table is an SQL Server ... I need to read it from the SQL Server database ....

HI,

I have a source table in which the date is stored in GMT format. I need to convert the GMT format date to EST format(for some months i have to substract 4 hours and for other i have to substract 5 becuase of the day light savings). How can i do it in DS? Please advice .....

Hi all ,

Iam pretty new to usage of SAP in datastage
Could you plesae provide the documents or links for using SAP R/3 Pack and SAP BW Pack in datastage.

Thanks in advance

Hello

This kind of data is expected from the file. Is there any optioin

thanks

Hello I have the below record "acegfgh";"ghkj;ij12";";dfd"fd";"ghfhdd"gkjdgfd";"dff3##;" each field is enclosed in double quotes and separated by ; (semi colon) each field can have extra special characters. i used col import stage to parse ...

Hello I have a requirement where i will be getting the row such as 1234^;abcdefgh^;bc^;d^;efg^;rghu^;klmn^;bcd each field delimited by ^; Is there a way that i can extract each field by using Field function. I tired using the Field function but it didnt work .Earlier they used the single Field separ...

Thanks for the reply.

Could you please provide the setup steps. And also give information about dsenv file.

Hi all,

I need some help regarding the accessing of Oracle10g database in Datastage 7.5.2

And my job is datastage serverjob. Can i use ORACLEOCI stage to access the Oracle10g database. or Any plug-in's i have tio install to access.

I appreciate your help.

Hello I have a requirement as below Column1 Column2 01-2009 +212.08 02-2009 +313.05 03-2009 -212.04 04-2009 +112.06 05-2009 -117.23 and my out put should be like If column1 starts with 01on source side then i need to populate the data of column2 from source to Col1 on targtet and the reaminig fields...

hello chulett,

thankyou for your reply. In our case lets say we have table called PURCHASE and has field1, and field2. We need delete the records where field1='A' before we do inserts into the same table. we dont have any keys defined on the PURCHASE table.

Hello I have a requirement where my source is flat file and target is Oracle enterprise stage. I have to insert the data into oracle enterprsie stage before i do that i want to delete certain recrods and then do the inserts. Is it possible to do the Delete first and then Insert in the same oracle en...