DSXchange

Hi All We are using SAP R3 extarct plugin, for extracting data from SAP IDOC. Issue we are facing is IDOC are coming in arge number to handle it causing delay in IDOC processing . We want to chnage the job design such way it only picks up limited number of IDOCS from queue say 10K and then process t...

hi

In my job in funnel stage I am getting following warning

Funnel_219: When checking operator: Dropping "ZPOSITION" in transfer from "inRec" to "outRec". [api/transfer_rep.C:1811]

Can anyone let me know what this warning is and how to remove it?

thanx in advance

chulett wrote:Multi-byte character set? ...

the field I am getting from DataSet and is of type char with length 40

Hi My job failing with error esql complaint: ORA-12899: value too large for column error is coming while updating , the field which giving error has length 40 before database stage there is trnasfpormer stage and in transformer have derivition like if isnull(columnname) then setnull() else left(colu...

Thanx for your reply .. I am having discussion with DBA they are also analysing the issue. This job never failed in last 2 years this is 1st time we are facing this issue only clue we do have that before running of this job DataBase server was shut down for an hour for maintainence purpose ... Since...

HI My job design is like oracle ent. stage ----> transformer------> seq file stage ususally this job fetches 5000000 rows from orace tables and write it to seq. file and take 2 hours to run but today it stuck up after fetching around 20000000 and stuck up in running condition neither giving any erro...

Hi All ,

when I am trying to schedule the job from datastage director, I am getting the below error.

"Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG62 "

Can any one suggest what can be the reason for this error and how should I rectify it?

Thnx in advance

Reset if required is needed to rerun an aborted job, a key need when building restartable Sequence jobs. If you simply say "Run" and the job is Aborted, the attempt to rerun the job will fail. ... Thank you very much ... Now I am able to create a restartable sequence job n its working fine

thanx for your suggestion. I am aware of wht it will also gone thru DataStage PDF anf got clear understanding of it.

Can you please explain relation between restartable sequence job and execution action option RUN and Reset if required, run

Hi All , We have created certain server jobs for interface say ABC.Those jobs are for extraction, transformation, load. Then we have created certain sequence jobs for extraction, transformation, load where all the severs jobs are added . These seuence jobs are then added in master sequence job of ou...

ray.wurlod wrote:Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output ...

thks

Hi In my parallel job while doing lookup between a dataset and some db2 tabe getting following error lkp,0: When binding input interface field "XYZ" to field "XYZ": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use a modify operator to ...

Hi all While trying to importing table definition using ODBC table defintion option I am getting following error. whats this error? How to resolve it? we have set up new development server on that only getting the error . Error message : DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error: SQLSTATE=S1000...

Hi all While trying to importing table definition using ODBC table defintion option I am getting following error. whats this error? How to resolve it? we have set up new development server on that only getting the error . Error message : DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error: SQLSTATE=S1000...

Hi


How to handle nulls in sequential file?
How to handle any other invalid data in Sequential file?
How to handle nulls in date in transformer?

Thanx in advance