DSXchange

Hi , Can I use more than one repeat(key column) element in xml output stage under input columns tab? Example:- input:- PORD1,DETAL1 PROD2,DETAIL2 PROD3,DETAIL3 Actual Getting output:- <IDOC> <PROD_HEADER>xyz</PROD_HEADER> <PROD1> <DETAIL1> </DOC> <IDOC> <PROD_HEADER>xyz</PROD_HEADER> <PROD2> <DETAIL...

some object for this job is corrupted, so you need to delete it from repository tables. 1. Get the Job id 2. delete from ds_jobs where NAME =<job name> 3. delete from JOB_OBJECTS WHERE NAME =<job name> just check the column names, not sure its NAME or JOBNAME. List and Delete commands not able to f...

tehavele wrote:

thumati.praveen wrote:When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same

Are you able to open that job in the designer ?

Yes I can ,but the probelm is I can not compile/run the job.

When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same

Hi,

Can any suggest the way to delete the jobs from project?

Jobs designs are avilable in designer but not in Adminnistrator and director clients.

Thanks,
Praveen.

Hi Praveen, Or is it some non english character. Please check the NLS settings. Try using column import stage. Thanks, Hi Birendra, source file coming from Mainframe with some columns binary type and some columns CHAR type. I tried using Cexport and Cimport stages I am not able to get it done. Than...

Hi, when we right clik on the stage and view the data it is allowing.But when I ran the job I got following error. error code is DB2_UDB_Enterprise_1: Error Idx = 5; DB2Driver Embedded SQL message: SQL0401N The data types of the operands for the operation "IN" are not compatible. SQLSTATE=...

dsimport (client exe) will import the job into the server. You can write a bat file and do the looping to import the jobs, or the simple way could be concatenate all the 50 jobs to a single dsx and import the concatenated dsx. Hi, Are you sure it will import both designs and executables? Thanks, Pr...

Hi, By using the import command in unix we can import only the job executables.Is their any equalent command in windows to import the job with designs and executables. I have 50 jobs in repository each have one dsx file in my local machine.I want import 50 jobs into new project.All at one time is th...

I was split the job then it is working fine.

Thnaks,
Praveen.

Hi All, I have one sequence and inside I am calling one job. If I run the job through the sequence it is not working but I run individually it is working fine. when I run through the sequence the lookups are not matching it is giving nulls because of nulls the transformer dropping the records.If I r...

Roopanwita wrote:I coudn't find $APT_PAD_CHAR parameter.
Already I have made Ref as Bedor & Stream as After link and also set same logic (1 -insert,3 update)
But though there r changed value in reference no record is coming out of CC.

Both links should be same partion method.

Roopanwita wrote:I m using Explict Key & Values option

The stream link should be after and refrence link should be the before in CC link order.Finally what Change code it returns identify if it is 3 then the source record was changed if it is 1 then new record.

I want Error detail My code looks like $INCLUDE DSINCLUDE JOBCONTROL.H Ans = 0 Errorid=0 ErrorDetail=0 jobname=' ' handleJob = DSAttachJob(JobName, DSJ.ERRNONE) If NOT(handleJob) Then Errorid = -99 Ans = DSGetJobInfo(handleJob, DSJ.LOGFATAL) Errorid = DSGetNewestLogId (handleJob, DSJ.LOGFATAL) Even...

once check the link order and what method your using? (Example:Allkeys Explicit values,Explicit keys Explicit values like this...)