Search found 22 matches
- Wed Mar 14, 2018 11:30 am
- Forum: General
- Topic: Job status within a sequence
- Replies: 10
- Views: 5340
- Wed Mar 14, 2018 11:27 am
- Forum: General
- Topic: Job status within a sequence
- Replies: 10
- Views: 5340
- Wed Mar 14, 2018 9:14 am
- Forum: General
- Topic: Job status within a sequence
- Replies: 10
- Views: 5340
Job status within a sequence
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.
Job 1---> Job2 -- Sequencer---> Job3
I would like Job1.status to be given as a parameter in Job 3.
- Fri Jul 28, 2017 3:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
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 ...
- Fri Jul 28, 2017 8:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
- Fri Jul 28, 2017 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
- Fri Jul 28, 2017 7:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
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...
- Thu Jul 27, 2017 2:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
Re: Header on import via FTP enterprise stage
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)
This above error happens whenever all columns are made varchar(255)
- Thu Jul 27, 2017 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header on import via FTP enterprise stage
- Replies: 11
- Views: 5319
Header on import via FTP enterprise stage
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...
- Wed Jun 21, 2017 8:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: BLOB text from SQL server
- Replies: 0
- Views: 2359
BLOB text from SQL server
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...
- Thu Jun 15, 2017 6:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage text handling
- Replies: 0
- Views: 2481
Datastage text handling
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...
- Thu May 18, 2017 6:40 am
- Forum: General
- Topic: Oracle RAC request
- Replies: 7
- Views: 4306
- Thu May 18, 2017 6:39 am
- Forum: General
- Topic: Oracle RAC request
- Replies: 7
- Views: 4306
- Wed May 17, 2017 9:22 am
- Forum: General
- Topic: Oracle RAC request
- Replies: 7
- Views: 4306
- Tue May 16, 2017 1:48 pm
- Forum: General
- Topic: Oracle RAC request
- Replies: 7
- Views: 4306
Oracle RAC request
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"