DSXchange

I am thinking this is a web services connectivity error. JOBNAME_XXX.Add_Call_Info_Tfm: DSD.StageRun Active stage starting, tracemode = 0. JOBNAME_XXX.WS_Make_Call_Tfm: DSD.INTOpen Active stage starting, tracemode = 0. JOBNAME_XXX.Receive_Response_Tfm: DSD.INTOpen Active stage starting, tracemode =...

Make the outputs from the aggregators in to reference files to a lookup joining back on to the source rows... you may have to push all links to passive stages prior to doing a lookup. Or separate jobs as previously suggested... Question is why you need to log an aggregated value against all source ...

Yes, but you've already marked the thread as Resolved, so why don't you tell us? This will assist anyone who encounters the same problem in future. Yes, it's a silly error, but we all make those, especially while we're learning. Don't be embarrassed about posting something that will help others. I ...

Consider a separate job to read the link row counts from the completed job and put the row into the table. Create a generic routine to read a link row count, given the job name, active stage name and link name. Is it possible to get the total rows passing through in a xformer using stage variable??...

Hi , http://picasaweb.google.com/dganeshm/DS#5431517736817687890 What I need to do is, I need to get the total records that is originating from ODBC_0 , and the number of rejected records from Transformer_27. But have to insert these numbers in the same row in a table. When I tried to do it , I was ...

SQL statement:UPDATE AMPSBX.dm.DATALOADHEADER SET RUNTIME = ?, ERRORCOUNT = ? WHERE (JOBNAME = ?) SQLSTATE=IM974, DBMS.CODE=0 [DataStage][SQL Client]Parameter marker text size exceeds allocated space JOBNAME = "CopyOfCOMPANIES_SX" RUNTIME = 0 ERRORCOUNT = 31 Can any one tell what is the re...

Thanks chulett, thats a good learning for the day...

Here are the two queries I have written in the ODBC stage in a Server job.. INSERT INTO DATALOAD(RECORDKEY, RECORDTYPE, MX_MESSAGE, DSJOBNAME) VALUES (?,?,?,?); UPDATE DATALOADHEADER SET ERRORCOUNT = 0 WHERE JOBNAME = DSJOBNAME; The error I am getting is : DSD.BCIOpenW call to function SQLPrepare fa...

http://picasaweb.google.com/dganeshm/DS#5431162210178227890 [/img] Please see the URL above to see the design of the job. What I am trying to do is that .. DSLink32 will give me the total number of rows passing through it, for which I am DSLinkRowCount in the transformed (Transformer_27) and use th...

Why not use a simple DataStage job? How do you identify the rows that you want to compare? Or is the question that you want to compare domains? (That is, the set of values in a column in Table A versus the set of values in a column in Table B. Information Analyzer can do that.) What's specific abou...

ray.wurlod wrote:Please be more specific about what you mean by "compare". QualityStage may not be the tool of preference.

Compare as in checking whether the values in columns of both the tables is the same.

Hi,

I am trying to compare if the data in one column is same in two different tables in different databases, how do you think I should go about this in QualityStage , please advice.

You could always take up little burden yourself, it's a good learning opportunity. Plenty of references for UNIX commands out there, including how to use 'find' for files of a certain age and then feed the results to other commands (like 'rm') via the '-exec' option. what would be the disadvantage ...

chulett wrote:That should be fine parameterizing the port address but as noted that doesn't seem to be your problem.

Craig, Lstsaur,

Only when I parameterize I am getting the error , when I leave it as is shown in the Img in the first posting I dont get the error.. that is what is puzzling me..

....using JavaPack means more than just writing a stand alone class....sorry I wasn't more explicit. You write your class according to the api as defined for JavaPack (it's not hard to adapt an existing one). Search thru the forum here...there are a ton of threads on it...I also have a sample at my...