DSXchange

Leomauer, Earlier I tried without CHAR(254) only. But it was giving error: AfterJob (1): The sql statement is sqlplus<<endofsql -S aaa@bbb/cc11 INSERT INTO APPS.XYZ(SERVER_NM,PROJ_NM,JOB_NM,JOB_STATUS,START_DT) VALUES(pa12,Test,JobNamesFromSequence,0,2007-09-10 03:59:23); exit; endofsql AfterJob (1)...

Chulett,

There is no other log entry which shows the actual command executed.

Regards,
ssunda.

The whole code is as follows: $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSJ_XFUNCS.H sJobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) Call DSLogInfo("Job Name : ":sJobName, DSJ.ME) sProjName = DSGetProjectInfo(DSJ.PROJECTNAME) Call DSLogInfo("Project Name : ":sProjName, DSJ.M...

Sorry. By mistake I missed copying that statement here.
I used the above DSExecute statement. I have used "UNIX" only Ray.

Regards,
ssunda.

Hi All, The routine is trying to insert data into an oracle table. And Iam using DSExecute with sqlplus to insert data. The code is as follows: SQLSTMT = "sqlplus<<endofsql -S abc@dddd/xxx":Char(254):" INSERT INTO APPs.LOGDATA(SERVER_NM,PROJ_NM,JOB_NM,START_DT)" SQLSTMT := "...

Thank you very much Kenn.

After using 'LOGTO project' statement, it got executed perfectly.

Regards,
ssunda.

Hi All, My requirement is to fetch the job names involved in a particular sequence. I used the following query in Datastage administrator and it successfully returned the jobnames of a sequence. SELECT EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',31,'X')" AS JOBS FMT '35L' FROM DS_J...

I am able to insert a blank field(one space) manually into one of the Varchar2(1 char) field of the table.

Arnd, In one of the sql loader documents, I found the following statement: Although VARCHAR fields also contain character data, these fields are never trimmed. A VARCHAR field includes all whitespace that is part of the field in the datafile. That means, the blanks should have been inserted as blank...

I have imported the metadata for table using Load->Import->Plug-in Metadata Definitions I tried fixing it, by changing the column definition from varchar(3) to varchar(1) manually in the oracle stage. It is still giving the same error-ORA-12899. When I dont use the env variable (APT_ORACLE_PRESERVE_...

Hi All, I went through the posts related to preserving blank spaces(adding env variables APT_ORACLE_PRESERVE_BLANKS) and tried them out. But still my job is getting aborted. I have blanks in some of the character fields coming from input file and want to store them as blanks instead of NULL in oracl...

The following are the properties set on Sequential file stage. Record type =implicit. Field defaults->delimiter=none General->Character set=EBCDIC Data format=binary Decimal->Allow all zeroes=yes I have neither used Record delimiter nor Final Delimiter. Dint use Record Length Property also. But I tr...

Ray,

When I changed the record type=implicit to Record delimiter=unix terminator(dos terminator), the job is getting aborted as it is not able to find those line terminators.

Arnd, I have 6 similar jobs and all them are having this warning(with diff record lengths) when using 'LOAD' option. I checked the control file created in /opt/etl/scratch directory in unix. The record length calculated by sql loader is 272. table definition in the control file is as follows: Column...

Arnd,

I tried with UPSERT. No warning when using UPSERT.

Ray,
The input file properties mentioned in the sequential stage are

Record Type =implicit
Field delimiters = none
character set=EBCDIC
Data format=binary
Decimal- allow all zeros=yes