DSXchange

HI Friends, Thanks for your support. :D I did simple excercise as you suggested.Now im able to view the data. I got that error message becz of that column name with spaces. My column name is like client_stg$.Source table name.I have used the option GetSQLInfo button (stage properties) as Ray suggest...

HI FOLKS,

We are using transaction size of 5000 but thats for commit rt?

Now we are discussing that with our DBA.

Hope the best.

Anyway thanks for your suggestion.

With regards,
Poornagirija.

HI Friends,

Thanks a lot .

I have started working on that with lots of enery from your words.

Sorry for posted the topic in PX.

with regards,
Poornagirija.

HI folks, :D Is there any option available in DataStage to get the data directly from xl sheet. :?: currently we are manually converting the xlsheet into csv format and using sequential stage we are achiving our results. We want to overcome this manual interuption. Any suggestions please. Many thank...

Thanks Arnd,

I will go through Ascential support as u suggested

By the way whats that bad libraray?and whats mean by reverting library?

with regards,
poornagirija

HI FOLKS, I have installed a patch on my client machine which is the patch for ecase 62522. I followed the installation steps mentioned in that release notes. Start->Run regsvr32.exe "C:\Program Files\Ascential\DataStage7.5\jobseqpages.dll" [assumes default install location - modify if nee...

HI,
I have checked in another project,no such problem there.
I think we have to re-index.

Thanks for your response.

with regards,
poornagirija.

Hey,
I was confused im able to see some jobs under the folder but some jobs are not visible.
Is any option we have to set before designing sequencer....

Jobs under the categories are missing.

HI, First i have created all the jobs under folder like Layer1\Folder1\jobs I have compiled those jobs. Then i started creating a sequence for them,i struck :shock: when i couldnt find any of my jobs under the folder and the OK button was disabled eventhough the folders were clicked. Any idea :?: Th...

HI FOLKS, I have created some jobs and i have saved it in subfolder like Layer1jobs\Load1. I have to run those jobs using sequencer. when i opened the jobactivity in jobname i couldnt find any of my jobs which has been created under the folder. How to attach those jobs which are saved under folder. ...

Hi,
Thanks for your Response.

Its actually a privilege issue.We have rectified that.

with regards,
Poornagirija.

HI Folks, Im working in DataStage 7.5 server edition. Our DS server is in windows 2003 and our DS client is in windows2000 professional. I have desinged one job of extracting the data from siebel source on oracle DB and populating the same to Oracle DB using OCI stage. While trying to view the data ...

hi, im new to Datastage.im trying to use stored procedure in ODBC. while importing from stored procedure definitions,im getting the following error DSR.MetaGeta(GET.PROC>COLUMNS)(DSSQLprocedurecolumns("","SCC BCI ERROR:Error calling SQL Fetch- SQLSTATE = 22003,NativeError = 0,ErrorMsg...

Hi all,
i need to know how to update seq files. since we have the option of overwite the whole fiel or append.
need to populate Dimensions of TYPE 1&3 SCD from seq file in the stages area............ help please........

thanks in advance