DSXchange

what does this error mean

DSD.BCIPut call to SQLExecute failed.

SQLSTATE=60, DBMS.CODE=-805
[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][DB2]7604


Thanks
Mark

If i have user defined routine can i use the same routine inside another user defined routine , from my testing i believe we cannot do... is it right

Thanks
Mark j

Hi

This is a general question. How will you configure processing nodes and is there any limit for processing nodes for a processor and do we need to do any scheduling for nodes... i don't know whether these questions are appropriate, but well these thoughts bugs my mind.


Thanks
Mark

Craig, Make sure you've got columns defined for all of the fields being returned by these queries... How are you 'joining' the two results? There doesn't seem to be a 'key' field in your lookup. :? I have all the columns defined for all the fields being returned by queries and prog_id and agmt_prg_i...

for driver table SELECT a.PROG_ID,a.AGRMT_PRD_ID,a.PROG_OPT_ID,a.PROG_OPT_DESC FROM sds.t_prog_opt a where a.agrmt_prd_id=(select max(b.agrmt_prd_id) from sds.t_prog_opt b where a.prog_id=b.prog_id ) for lookup table select distinct a.prog_id, a.agrmt_prd_id from sds.t_enty_xpns_desc a where a.agrmt...

I am getting following error and the job is getting aborted

:Error while trying to retrieve text for error ORA-01036


can any one find a solution to this error

Thanks for your suggestions I phrased my question wrong:) if i have more than one space it should be replaced with single space as in following example Mark jason Oakman then the result should be Mark jason Oakman you never know for sure how many spaces you have... I hope i am clear enough with my q...

Hi

Is there any function to do following simple task

I have an input : Mark?????Jason i want to make it Mark" "Jason


Thanks
Mark

Hi Kenneth,

You are right , i am getting error messages due to handling of empty strings but why do these errors doesn't show up on the job log..


Thanks
Mark

Hi When i am running a job which has 4 lookups and a driver file with 30 million records and 5 output files and each of these files are directed to seperated directories then why while running the job, When i looked into project directory this file is increasing in Megabytes as processing for job is...

But its daily process , then how can i automate using db2fast export onto a sequential file...

and what i wanted to do is get the mssqlserver driver file into db2 and then do a join ..... i haven't tested the performance but i think it should imporve the performance...


Thanks
Mark

and how to join between 2 tables if they are from different databases
main file is from mssqlserver and reference file is from db2udb ... i need to do this using sql.... is it possible

but, if i preload to a hash file with 30 million records then its taking around 5 hrs to populate the hash file... which i guess is not improving the performance that is very much required in my case as, this job run on daily basis..... so loading to hash file is 5 hrs and processing the lookup is a...

HI
How can i join between 2 tables one is from db2 and one is sqlserver (driver file) which stage should i use to do this???

thanks
Mark

Hi All, Our company is planning to purchase parallel extender with huge amount of data to process..... and already we have jobs designed on server canvas is it possible to migrate to parallel canvas with out any design changes and take advantage of parallel processing what actaully are tradeoffs bet...