Spaces error at sequence level
Posted: Mon Jan 10, 2011 3:30 am
Hi Mentors,
i have one sequence attached with several job like
job1--->job2---->job3---->job4--->job5
there is no abosolute depedency between these jobs. only it shuld be run one after on like after job1 then job2 then job 3
now problem is when i run this sequence and when check o/p of job4 it produce o/p like op1
and when same job4 i am running alone it gives proper o/p like op2:
job4 designe is like :
db---trx--o/p(seqfile)
the column are of manily char type. i suspected some space so used trimleading trailing and stripextra space function.
it gives me proper output when i alone run the job, but when run with sequence it gives lods of space as shown(op1:)
on sequencer level i have used trigger conditional like
job.$JobStatus<3
also used APT_PADCHAR paramaeter and value is 0x20 to remove any junk and spaces from db.
i hope given a clear picture.
please let me know if you need anything else.
this have stucked me in my testing
thanks,
Devesh
i have one sequence attached with several job like
job1--->job2---->job3---->job4--->job5
there is no abosolute depedency between these jobs. only it shuld be run one after on like after job1 then job2 then job 3
now problem is when i run this sequence and when check o/p of job4 it produce o/p like op1
and when same job4 i am running alone it gives proper o/p like op2:
Code: Select all
op 1:
"12","TGMIS00 ","MSR_PRD_MO ","TGMIS00 ","MSR_PRD_MO ","INSERT "
"12","TGMIS00 ","TEL_ADR ","TGMIS00 ","TEL_ADR ","REPLACE "
op2:
"12","TGMIS00","MSR_PRD_MO","TGMIS00","MSR_PRD_MO","INSERT"
"12","TGMIS00","TEL_ADR","TGMIS00 ","TEL_ADR","REPLACE"
db---trx--o/p(seqfile)
the column are of manily char type. i suspected some space so used trimleading trailing and stripextra space function.
it gives me proper output when i alone run the job, but when run with sequence it gives lods of space as shown(op1:)
on sequencer level i have used trigger conditional like
job.$JobStatus<3
also used APT_PADCHAR paramaeter and value is 0x20 to remove any junk and spaces from db.
i hope given a clear picture.
please let me know if you need anything else.
this have stucked me in my testing
![Sad :(](./images/smilies/icon_sad.gif)
thanks,
Devesh