DSXchange

Sainath.Srinivasan wrote:You say that your source is sequential file and target is Oracle.

But you use 'SELECT' clause !!??

Are we missing something ? ...

It's not a user defined sql and I am using Oracle stage (write method = load , write mode = Truncate)

chulett wrote:That's not what you posted says.

Make sure you've supplied the correct schema, you are connecting to the correct instance and have select grants on the table. ...

using global parameters, Other jobs running fine.
I can insert data manually into the table.

srinivas.g wrote:provide Schema name

query is: select * from CDM.GROUP

Dear All, We are having below problem in one our jobs . The job is simple load job which loads the data from Sequential file to ORACLE table. Same job is working fine in Development environment. The target table is available in database. Source : Sequential file Oracle stage (write method = load , w...

How to uninstall Data-stage client 7.5

JOB was aborted and disappeared from DSdirectory but the same job was available in DS designer , when i try to open the folder where the job is supposed to be there i am getting the FAILED TO OPENRT_LOG228 FILE ERROR please help me out on this issue

Hi All,

I would like to know how many jobs available in Datastsge project.
How to import all job names from a datastage project .
I am using Datastsge 7.5 and OS Unix.
Is any option available in Datastage 7x to get all job names at a time, without manually.

Thank you,
:D

ray.wurlod wrote:Technically // is not legal in a UNIX pathname. That's your root cause.

Some UNIXes ignore it, but technically it's illegal. ...

These jobs will run every day.
I am analyzing Why it came only one day.

Thanks,

And *I* want... well, never mind what exactly it is that I want. As I said, I've had no issues with this, from either sequential file pathnames to pathed hashed filename so perhaps it varies from UNIX to UNIX. As noted, this typically comes from combining two parameters with a hard-coded slash (or ...

chulett wrote:Wait... does 'ignored the slash' mean 'removed the extra slash' here? It fails with two slashes but works fine with one slash? ...

with two slashes it failed but works fine with one slash.

I want root cause for this.

A "double slash" usually isn't a problem. Ignoring that, are you certain the hashed file at that path otherwise exists and is accessible? ... Chulett, Thank you for your help. Ignored the slash(/) and ran the job finshed successfully. I am doing root cause analyzing. Please help to me on ...

Does the parameter value for the directory have a terminating slash and this particular job have a slash between the parameter reference and the hashed file name? ... Ray, Thanks a lot for your quick response. we have parameter value for each directory (/) and also we have a slash between parametrs...

DSD.UVOpen Unable to open file. Hass file unable to open. Sequencer have parametes as normal and same parameters will be use for every job in the sequencer. But a job got a extra slash (/). All jobs completed successfully except that job. All Parameters are default from UNIX.(defined in Unix) Schedu...