DSXchange

Hi,

I am using UDB DB2 database,i need to open a database connection and get maximum value of column from table using Before/After Routine.So is there any procedure to do this?I am using Enterprize edition 7.0.1.

this is urgent.


regards
Beeram

Hi,
I am using the upsert method it's working well,check the partition type and excecution mode.

Regards,
...Thirupath Reddy

Hi,

Datset


Thanks
Thiru

Hi Lakshmi,

You can use default value for Null Column.If you check in properties of DB2 Enterprize stage you will have default value property for null column,there mention zero.

thanks
Thirupath Reddy

Hi Kruthika, Follow these steps to get previous month last date: 1.Get month no using MonthfromDate() then store in a stage variable(say..sgMON) OR (you can use LEFT or RIGHT or Field to get month no) 2.Get year using YearfromDate() function then store in a stage variable(say... sgYN) 3.Concatinate ...

Try in this way:

1.Declare file Name as Job Parameter in job properties
2.Use DSGetParamInfo(DSJ.ME,ParamName, DSJ.PARAMVALUE) then pass the Job Parameter .

venkat beeram

Hi,

What exactly u want the Output in number of days OR in date format?

Hi,
Waht is the best metod for restart of jobs in datastage 7.0.1

Thanks
Vbeeram

l_homme_de_rio wrote:Hi,
Are you using DS Server or PX ???
All The best

I am using parallel Extender

what is the difference between DB2 API and DB2 Enterprise stages?
which one gives better performance?


Thanks
beeram

Hi, I am reading date values from Excel file(.csv) data in the mm/dd/yyyy,i used Sqquential file stage to read the data and i have to write this date into UDB DB2.here IConv and Oconv are not working as iam using Parallel jobs. I used Varchar data type in Sequential file stage. I used StringToDate f...

Hi,

I am using Datastage 7.0.1 Parallel Jobs,when I am trying to use IConv and OConv Functions I am getting error,like Variable not found.So can we use Iconv and Oconv in parallel jobs or not.It's urgent if any body give reply i would appreciate them.

Thanks


Beeram

"Thanks I got it now" Hallo vbeeram The best way to handel a record that changes slowly over time is to use the checksum function - its much better than doing an AND..OR statement that is tedious to type and difficult to manage. From Help: This example uses the Checksum function to return ...

Hi,

How to make connectivity for Peoplesoft EPM from Datastage

thanks
vbeeram

Hi,

What is the best way to generate surrogate keys in parallel Extendeer jobs.

thanks
vbeeram