DSXchange

hi All We have some basic code which does some functionality for us. We rote the code in jobcontol and with minor modifications like adding the header files we are able to use it great in a routine and call it from a transformer. Which of the two approaches is better and what is the trade off using ...

hi ray and wolfang i guess i did not make myself clear with the problem.i will just try to explain in a different way. i have 20 sequential files with different schemas. i created 20 tables in my database as i am using a database approach and my model is built around a database approach. each countr...

hey
i have lots of tables as well. i am not targetting a single table.

Thanks and Regards
Pavan

hi ray Thanx for the pdf. can you please elobrate on "your ODBC connection will only work for 30 days using BCI functions then you will need to purchase a licence for the ODBC driver from DataDirect Technologies". can you tell me any other solution for my problem? i mean simpler way of ach...

hi
can any please share with me the below pdf
UniVerse BASIC SQL Client Interface Guige (BCI.pdf). the archives says i can find what i am looking for in these pdf's

Thanks and Regards
Pavan

hi all Problem: i have some data in a sequential file i want to rite the data present in that in to a odbc table using a basic routine(lots of files and lots of tables didn't want to make my job look complex so trying to achieve this with a routine) i succeeded in opening the file and reading the da...

hi All Can you tell me which one of two is faster the hash file look up of server or the join stage of parallel extender. Consider that i do the hash file look up on my server canvas put it in a shared container and execute on parallel extender will this make my job faster than just using a join sta...

Hi Ray
It looks a bit too hi-fi but anyway great pointer. i will see what i can decipher out of that code

Great ready for more questions from my side

With great knowledge comes great questions :D

Thanks and Regards
Pavan

Wow
Great reasoning buddy ?it is working fine for a single row of data but aborting if i put another row.

can you guys please tell me how i manage my code if i have more than one row of data in my input files

Thanks and regards
Pavan

hi All I am trying to run a job from another job using a sub-routine. i created a job BasicTrial SeqFile-->Transformer---->seqFile In the Transformer i called a subroutine BasicTrial("JobName") In my case it looked like BasicTrial("AcctCustSeqTrial") My Job AcctCustSeqTrial is co...

hi All

Thanks for the replies. it is working great now

Thanks and regards
Pavan

Hi All Can you please point me out the mistake in the following Subroutine DEFFUN DSGetJobInfo(JobName,Info) Calling "DSJ.DSGetJobInfo" Ans=DSGetJobInfo(JobName,Info) It is compiling fine but when i give proper values in JobName and info it is giving me error The values i m passing as Arg ...

hi Ray Both the solution worked great Thanx a lot. Are all the types of calling User subroutines applicable for only Subroutines? if i want to call an user defined Transforms how do i do it? Can you also tell me what are various kinds of transforms and how they can be called from a user defined sub-...

Hi Ray
The A4 Solution didn't work out even though i dedicated the first argument for the returning value

Can you also please elobrate on the subr() function which you said can be used for calling user defined subroutines.

Thanks for the help

Thanks and Regards
Pavan

Hi All I am working on subroutines.i rote a small subroutine with name CalledSub.it just adds to numbers and returns Ans.i compiled it and Tested it. Now i have another Subroutine CallingSub which needs to call this subroutine. and use the value what it returns. I have searched the forum and found t...