DSXchange

sorry typo mistake.Here is the correct sample of records

Hi all,

Would you please let me know if there is a way to read variable number of columns from a sequential file
.


Sample data:

SQLSTMT = 'sqlplus<<endofsql -S ':OraUsrId:'@OraInstance/OraPwd':Char(10):'set head off pages 0;':Char(10):'SELECT COL1 FROM table':Char(10):'exit;':Char(10):'endofsql' Call DSExecute('UNIX',SQLSTMT,Output,SystemRetValue) If FMT(Output,"L#1") = 'N' Then Output1='N' END Else Output1='Y' En...

could you please let me know if we could suppress the newline characters in routine itself.

Thanks,
Elias.

Here is my routine code. SQLSTMT = 'sqlplus<<endofsql -S ':OraUsrId:'@OraInstance/OraPwd':Char(10):'set head off pages 0;':Char(10):'SELECT COL1 FROM table':Char(10):'exit;':Char(10):'endofsql' Call DSExecute('UNIX',SQLSTMT,Output,SystemRetValue) Call DSLogInfo("Output is ":Output: "R...

Hi all,

I have a routine which will execute a SQL statement.

Lets say SQL statement returns value 'N'.

But when i check the result,i am seeing 'N' and a new line character.

How do i eliminate those new line characters.

Appreciate your help.

Thanks,
Elias.

Issue is resolved

We have used timestamp format in columns tab.

Query is auto generated. Date format wasn't working.

Thanks to all for your support.

Thanks,
Elias.

we have changed the query to auto generated query and SELECT TO_CHAR(CAL_DT, 'YYYY-MM-DD HH24:MI:SS'),FSCL_YR_NUM FROM TBLNAME WHERE CAL_DT=TO_DATE(:1, 'YYYY-MM-DD HH24:MI:SS') But the job is giving different kind of errors.Just want to know whether we can use oracle stage (OCI) stage as reference t...

In columns tab it is 2nd column.

If it is not answering your question then i must have misunderstood the question.


Thanks,
Elias.

Here is the SQL query i have used.

select FSCL_YR_NUM , TO_CHAR(cal_dt, 'YYYY-MM-DD') from TBLNAME

And data type for FSCL_YR_NUM is integer and data type for cal_dt is Varchar2(10).

Cal_dt is my key column used for doing lookup.

Thanks,
Elias.

Hi all, In a server job i have a sequential file as source and oracle table as lookup table. And using transformer we are doing lookup on oracle table. The problem is,job is aborting with below error . "ORA-01036: illegal variable name/number" . But we are able to do view data properly fro...

Hi All, Is it possible to create a job template(for parallel jobs) from a existing job.And can this template be used by multiple users . If yes, what are the drawbacks of using a template. When i tried to create a template it gave me below error.I believe i need access on some folder to create templ...

Hi all,

Could you please let me know if a routine can return multiple return values ?

Hi all, We are trying to find a solution to identify the sequence which has triggered/started the parallel job. Example: MainSequence | | Seq2 Seq3 | | Job1.Seq2 Job1.Seq3 From above example, I would like to know if there is any UNIX command to find out the master sequence name (MainSequence) of Job...

Then you can load the rejected records into a file( txt,csv).

And send a mail using routine or using a sequencer .

If you use sequencer check for record count using Execute Command stage,then send a mail based on the record count.