DSXchange

Hi In Source I have two columns one is eff_month, eff_year. those data type is char. I want to load in target as due_date (data type date) as month/year. I am doing concadination using to_date. in oracle it is working but in data stage I am getting error. Can any one help me how to do this rek. Tha...

[quote="ray.wurlod"]For something that simple, you could nest the Field functions. Field(Field(InLink.MyString, "^", 2, 1), "-", 1, 1) As Ray suggested nested field functions is good . Ray's function is resulting 12345678 Probably below is the one you are looking ,which...

deva wrote:I am doing concadination using to_date. in oracle it is working but in data stage I am getting error.

Did you try inserting into due_date field in Toad or anyother query tool you have using to_date function. Did the field accept???

how about

Step 1
A1= Field(Mystring,'^',1) which gives result=A12-ABCDEFG123456
then
A2=Field(A1,'-',2) which gives result=ABCDEFG123456

use stage variables to achieve this

Thanks
Paddu

Can you post an example . Probably makes easy to understand Something like this Table1 assume Jan-March Col1,Col2,YTD_balance 1,123,400.00 Table 2 assume Jan_feb Col1,Col2,YTD_balance 1,123,300.00 Result something like this ??? Col1,Col2,YTD_balance 1,123,100.00 If this is you are looking for then w...

[quote="chulett"]So... you 'resolved your issue', meaning you actually wrote a routine to connect to Oracle? Or did something else? :? quote] No i did not write a routine to connect to Oracle . I wrote a routine to get previous month value from the current date (@DATE). I did not use oracl...

Yes sir !!! i have something in my mind .. At one point i needed to get a date from oracle table to use in job sequences .Basically identify the month of date from oracle table and process rest of the sequence. According to our process , the date i am trying is always previous month date from the cu...

Thanks Chulett.

I checked the recent post after asking for the syntax here .

I will surely search the forum.

Thanks
paddu

Can you please tell how the syntax for DS routine could be to connect to Database??

Can we connect to Database ( example: oracle) and query to get any specific value in DS routine???

Thanks
Paddu

Thanks for quick response chulett.



is it possible to connect to Database (say oracle) and get any specific value in DS routine?????

If it is possible in DS routine then i think it can be used in jobs and job sequence also.



May be i need to start new thread for my new question.

is there any way stage variable can be used globally across the jobs???

I mean , capture a value in stage variable and use in more than one job ???

Is it possible?

I do not have any current requirement to do this but curious to know.


Thanks
Paddu

dstest wrote:I need the output like below

ID,CODE1,CODE2,CODE3,CODE4,CODE5
123,300,200,500,600,20,400,40,30,300,20

How many output columns you have ???

for me it was within 24 hours .

then please mark this topic as resolved