DSXchange

Hi All, I am trying to export a project by job level. And I using the below command but its exporting all the dependent items, executables etc for a job. "c:\ibm\InformationServer\Clients\Classic\dsexport.exe" /d=server /u=userid /p=password /h=hostname /EXEC /JOB=jobname projectname jobna...

Yes ArndW, I have connected to sql server before from datastage and was running some of my jobs.

I have created a new job to pull data for a table in the same server and its giving the above mentioned error

Hi,

I am getting following error while connecting to Sql server fron Datastage.

'Segmentation Fault - core dumped'

Can you please let me know if you have faced this issue before.

Any help is greatly appreciated.

Thanks
Sree

Hi,

I need to find the count of the records from the source Oracle stage which has SQL query in it.

Can we get any thing like to get count from the link.

Thanks for your help.

Sree

Hi, I have a primary i/p and reference i/p. both of them has same 2 key columns ex: primary Col1 Col2 Col3 1 A 123 1 B 456 1 C 768 1 D 345 Reference Col1 Col2 Col4 1 A XXX 1 B YYY 1 B ZZZ 1 C DDD o/p should be as Col1 Col2 Col3 Col4 1 A 123 XXX 1 B 456 YYY 1 B 456 ZZZ 1 C 768 DDD 1 D 345 Any help is...

Hi Ray,

Thanks for your info. But when i use the ODBC stage in server jobs,what username/pwd do i need to specify..is it the servername userid.pwd or ms access DB username/pwd to access those tables.

Thanks

Hi All,

I have a job where I need to connect to the MS access tables in a different server and they are stored in a perticular folder in that server.
They are in .mdb format.

May I know if we can access them in any why using any of the stages.

Thanks for your help in advance.

Hi ray,

Thanks for your reply,but i can see only DSJobStartTimestamp for start date but i didnot find any for endtimestamp

Does any one know how to get only the end date for a job as timestamp

Thanks

Hi all,

I have a job,and i need to find the start date and end date of that job.
Means start date is for when the job has begun and end date is for when it completed.and i need these as 2 different coulmns.Could any one help me on this.

Thanks
For your help in advance.

I should create a target table having blob and how can i do that in pl/sql
Can you please help me out in this

Thanks
Sree

Is there any way that i can do it to get the data from source having blob fied to target of bolb field

Hi All, I have one of my source column as BLOB and as oracle doesnt support BLOB i have used ODBC stage for both source and target and i need to bring the record from source to target.When I ran the job i am getting so many warning msgs as DSD.BCIGetNext call to SQLFetch returned informational messa...