DSXchange

Not strange. Toad just runs the sql and shows you the result, DataStage has to do more than that. It needs to put the results into variables (much like a "select into" in PL/SQL) and that is what is causing your issue. The question is, what are the data types of the columns in the job? An...

As I said, I did run the same job without the where condition and with same metadata. It ran successfully

Weirdly though, the same job works without GREATER THAN EQUAL TO operator within the where condition.

For example when I run the query with below where condition job goes fine

where
col1=(select max(col1) from table 2)

I have a strange issue wherein a query runs fine in TOAD, but not on Datastage Oracle connector, the job fails with error The OCI function OCIStmtFetch2 returned status -1. Error code: 1843, Error message: ORA-01843: not a valid month. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,729) T...

I am getting this error in Lineage Information for Information Governance Catalog The error occurs only for few views. Error linking view <ViewName> from schema <SchemaName>Error linking view View expression for ViewName is : I have tried re-importing all base tables in IMAM, also looked into Grants...

Did a workaround setting up dependency between the 2 jobs

We have a scenario with two ETL jobs(Lets call them Job A and Job B) belonging to different subject areas with no dependency among each other, but operating on same table. job A has the following statement ALTER TABLE <TABLENAME> TRUNCATE PARTITION (PNAME) UPDATE INDEXES job B does a simple select *...

Ok Ray. Is this script stored somewhere or redirected to a log file, where I can find it?

I have a parallel job that loads data from sequential file to Teradata Database using Teradata Connector stage in Bulk/Load mode.

Is there a way to get the SQL query that DataStage generates to load the data in the table?

I tried with the escape character but getting the same error

I have a EBCDIC file and I am reading it using a Sequential File Stage and Schema File with RCP turned on. The multi layout file has a header record which is 21 bytes. The Detail records are 2427 bytes long and the trailer record is 9 bytes long. I managed to remove the header by using tail +22c in ...

i did the following changes in the job Source Sequential File Stage ---> Read from Multiple Nodes Set to "Yes" The teradata connector was running in Sequential mode. So I changed the setting for Parallel Syncronization to "Yes" Also buffering mode was initially "Default"...

Read the file with a single column and then have a column import stage. In column import select option for schema file and have a parameter for the same. In this way you will have a single multi instance job but you will have 'n' schema file for n files. When you invoke the job just pass the paramet...

I have a job which reads from complex flat file and loads to an empty Teradata table. I am using Teradata connector with Bulk Mode (Load Driver). The table is multiset table and allows duplicates. It also has primary index. The incoming file is fixed width EBCDIC file with a row width of 7000 bytes....

Hmm..Pretty much..The DBA team suggested to have a primary index on the table and for that choose a column with unique values..But this is already taken care off. The table already has a primary index. In fact the table has only 3 columns in all..Out of that two columns are always nulls and the thir...