DSXchange

Hi,
In the target sequential file stage, if we specify only the file name with out complete path of that file, Where will be that file created? Is there any specific environmental variable to be set for default file creation path on the server!
Any ideas...

Thanks

Thanks Ray there are only 4 rows in the input file(there are only 4 lines in textpad). for the input sequential file stage and out put sequential file: using record level-final delimiter= end & record delimiter string = DOS format Field defaults-delimiter = none & quote = none. I tried chang...

Thanks ArndW I ran With just 4 rows. Its throwing the previously mentioned error for the last record only. My job is :SEQ_FILE ---> trans ---> SEQ_FILE INPUT FILE: I am reading this file as a single column as varchar """1234"""|"""2"""|&quo...

Hi all, I am tyring to use the unix replace comamnd 'sed -e 's/"""/"/g', in the filter of a sequential stage in parellel job. I get this error message "Filter status 65,280" -- the job gets aborted, but If click the view data button in the sequential stage( the stage wh...

Thanks Ray and bikon.
Ray, there are no warning messages at all in the job log except few fatal error mesasges.
bikon, i am not familiar with routines..may be i should look into them..

Thanks

Hi Savis,
What you are saying is correct. But my job is not failing(even though fatal errors)....the status after the job run is finished.So i cant use terminator.
I am running this job individually not through sequence.
Thanks

Hi Kumar, there are no message handlers defined. Actually there are duplicates in the input file to the database.So, dead lock situation occured, But wondering
whatever is the case, datastage is throwing fatal error and could not abort that job.

We are running a job which loads the database. The job has sequential file--->transformer--->odbc stages. The job finished successfully with out warnings.When we check the job log, there are fatal errors(deadlock occured). The job should abort if there are any fatal errors! right? These error messag...

ray.wurlod wrote:Are there any "funny" characters (for example "#", ,"?", etc.) in the password?

Password is a simple 'welcome'

ray.wurlod wrote:Have you also checked tnsnames.ora ?

Is casing as well as spelling correct?

Hello Ray,

tnsnames.ora has all the entries (spelling and casing are same) and we have no isses in connecting to database up on running a job.
This error is popping up only when importing the table def!

All the jobs (DRS stages) were able to run with out any issues using ODBC connection. An error is popping out only when importing metadata. "DSR.MetaGeta(GET.TABLES)(SQLConnect('abc','xyz')): BCI Error: SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][O...

Thanks Ray,
Any how the issue resolved...Actually some files in that project got compressed.after uncompressing those files, we are able to access DS director for that project..

Thanks..

Thanks Ray,
Any how the issue resolved...Actually some files in that project got compressed.after uncompressing those files, we are able to access DS director for that project..

Thanks..

Hi, I am not able to access Datastage Director.I tried to connect director through designer(tools-> run director) and through datastage director client. I am getting the following error message: Failed to connect to Datastage server:xxxxx.project:xxxx(the directory you are connecting to either is no...

Thanks Guys....