DSXchange

Hi Frank,

Looks like my copybook/text file imported good. I could able to read/view first line, It gives me an error for 2nd line onward
Like [####] Data Browser - ERROR.

What could have been an issue here.

We are trying to convert EPCIDIC file using Complex Flat File stage. one of the record is having COMP3 filed to convert. when we have all the field defined as character, job runs successfully and write the data into a sequential file. only issue is COMP3 field shows junk value. If we make COMP3 fiel...

You are right Craig. How do we pass the or get the ETLuserid in this QB section?

We are implementing the Query Band in the Teradata Stage in the DataStage Jobs.


In the Query Band Expression: set the following.

'ProjectName='#DSProjectName#;'JobName='#DSJobName#;'StageName='#DSStageName#

We are using DS8.7 with TD13 and planning to use the Query Band Option in the Teradata connector stage. I am able to give the parameter for all the DS project , Job name and etc. But we want to give the parameter as ETL login user name. Inside the job I can get it from the "Getenvironment("...

Hi, I too received this SIGSEV error message. So for I found it in two different scenario. 1. One is due to file system error. Either segmentation error or may not able to handle large volume size. Some time this will occur in the lookupstages.. Sol: Change the jobs to use Join Stage or Merge Stage ...

Still this issue has not been resolved. We are using Teradata API stage instead of Teradata Enterprise Stage. But its perfomance is very poor.

Hi Phanee,

Its a Teradata enterprise stage. even I set environment variables in user defined..thru administrator as

APT_TERA_SYNC_DAEMON_PROG = 'servername'
APT_TERA_SYNC_DATABASE = 'db name'
APT_TERA_SYNC_USER = 'user'
APT_TERA_SYNC_PASSWORD = 'pwd'..

Still the issue is there.

Hi, I am trying to read a Teradata table from the DS parallel job using Teradata Enterprise Stage. Its giving me the following error. Also can't view the data. TeradataTble: Unrecognized argument: -db_cs But I could connect thru DS manager to import the metadata definitions. DataStage Version 7.0 Te...

Hi,
recently we posted some work around...search for Err insert timestamp value (with Microseconds) into Oracle9i