DSXchange

Yes chulett it would work, as the Job1 would be completed and only on error the Job 3 would be called.

Thanks UCDI, yes this is what I was looking for. So if we go for a routine we would need to build a custom one or is there an existing routine?

Is there a way we can call the job status of the previous job, in a later job at the sequence.

Job 1---> Job2 -- Sequencer---> Job3

I would like Job1.status to be given as a parameter in Job 3.

So I am writing these files from FTP location into an HDFS location. By making the metadata varchar(max), I was able to achieve placing the files. However, I am having another strange problem. FTP enterprise is introducing a file descriptor record as the first line. ABC.dsv 201707280000 428 records ...

CHulett,

Yep, looks like it would need to call a shell script to do this. FTP should be simple pick up and drop.

Franklin, the table definition of sequential file has first row as header, checkbox. I had read these as columns into FTP enterprise. Yes, header reads first row as data row.

Yes, it is seeing something different. because it is reading the data with the header. The first column is date, but the metadata is report_dt date. Since it is reading header too it tries reading report_dt as date column. I tried unchecking first column is header, and setting all datalengths to 255...

Sequential_File_1,0: Fatal Error: waitForWriteSignal(): Premature EOF on node ditdwapp1w204m7 Bad file descriptor

This above error happens whenever all columns are made varchar(255)

I am trying to import a file via FTP enterprise stage. The first column is report date. I have kept the datatype as date and not as varchar(255). I have mentioned on the table definition that first row is header. When FTP imports the process it throws record input error as it reads the header row as...

Hello, We are reading some text fields from SQL server. I have tried a direct replacement of char(10), char(13) in the read select query. This query works in sql server. However while the datstage process runs successfully, the /n and tab replacements are not happening. The extract files have the re...

Hello, I have worked with several ETL tools, and have seen there are different ways to handle text fields. On importing a table definition the datastage has converted a text field into Longvarchar. The process then has to write into a hdfs location via hdfs connector, basically a .dsv file. Here are...

Correction: Its a development environment, hence a single node cluster. So why would it ask for RAC name?

Julio,

Unfortunately, I have limited access on the datastage environment.

chulett,

Yes, that is correct. Will take a look at this suggestion. Thanks.

When I try importing the tables from Oracle, despite correct connection details it requests RAC name. "User needs to enter RAC Name for servers on RAC"