Search found 7 matches

by vj_meghani
Tue Nov 23, 2004 12:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL SERVER
Replies: 6
Views: 2294

sotre porcedure

Hi. I am able to transfer all the table from sql server to oracle database.
Do U have any idea how do i transfer sql server store procedure to pl/sql . i am able to import the store procedure file how to conver them.

thanks
vaishali
by vj_meghani
Mon Nov 22, 2004 11:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL SERVER
Replies: 6
Views: 2294

Thanks a lot. I am now able to view the table and even transfer the data


thanks

vaishali
by vj_meghani
Fri Nov 19, 2004 9:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xls.files
Replies: 8
Views: 3587

Hi.
I upgrade Os to XP. I am able to get the data of XLS that is of only one file that i hv show in DSN.

How can i import all file together or how can i add all file together. Is there any way.

thanks
by vj_meghani
Fri Nov 19, 2004 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL SERVER
Replies: 6
Views: 2294

SQL SERVER

HI

I am tring to load table from SQL server to Oracle. but some how i am not able to see the actuall table that i hv to transfer it.
I am able to see some of the Master.dbo. systemtable, but none of the table that i hv transfer.

Can anyone pls help me on this.


Thanks
vaishali
by vj_meghani
Tue Nov 09, 2004 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 2
Views: 1065

Date Conversion

Hi

I am trying to convert date from yyyy/dd/mm to mm/dd/yyyy
I was also trying to convert the timestamp to dd/mm/yyyy.
I am not able to converte it. Can anyone tell what should i do?

vaishali [/code]
by vj_meghani
Tue Nov 09, 2004 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: excel files
Replies: 2
Views: 1116

excel files

I am trying to get and *.xls file. I have Window Xp as Os. In ODBC driver i hv set up excel drive also and loaded one worksheet on it. But still i am not able to load that in DS table defination.

Vaishali
by vj_meghani
Fri Oct 29, 2004 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xls.files
Replies: 8
Views: 3587

xls.files

i am trying to load files from excel but not able to load it. Can anyone help me out in this.

I have TNS listner prob too. how can resolve this porblem.