Connection to DB2 using a routine

abhilashnair · Post by **abhilashnair** » Fri May 18, 2007 8:32 am

I need to connect to the DB2 using a routine
and then fire a query "select * from schema.table " and write the result to a delimited file

DSguru2B · Post by **DSguru2B** » Fri May 18, 2007 8:35 am

Write a shell that invokes the db2 connect and runs the query via DSExecute() command. Ofcourse you can make it much easier and use a simple datastage job to do this.

abhilashnair · Post by **abhilashnair** » Fri May 18, 2007 9:24 am

DSguru2B wrote:Write a shell that invokes the db2 connect and runs the query via DSExecute() command. Ofcourse you can make it much easier and use a simple datastage job to do this.

I need to do this because we are testing whether a routine in DataStage can connect to 64 bit DB2 server. The DataStage client is a 32 bit application.

chulett · Post by **chulett** » Fri May 18, 2007 9:43 am

Haven't we already had this conversation? A 32bit application can connect to a 64bit database using the 32bit libraries the database provides. Simple. No routine or other shenanigans 'needed'.

pathmaker · Post by **pathmaker** » Fri May 18, 2007 1:45 pm

chulett wrote: Haven't we already had this conversation? A 32bit application can connect to a 64bit database using the 32bit libraries the database provides. Simple. No routine or other shenanigans 'needed'. ...

DataStage does not support connecting to the 64bit client and this will not work. You can still have a 64bit instance of your database but you must use the 32bit libraries. Having a 32bit client shouldn't be the problem. (other than memory issues)

-pratap
Chotu

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 6:02 am

I have written a routine
Equate RoutineName To "ConnectToDB2"
Equate DBNAME TO Arg1
Equate DBSCHEMA TO Arg2
DB2CntCmd = "db2 CONNECT TO ":DBNAME
ResultText = @Null

Call DSExecute("UNIX", DB2CntCmd, ResultText, SystemReturnCode)

If SystemReturnCode <> 0 Then
Ans = "1"
Return(Ans)
End

If SystemReturnCode = 0 Then
Ans = "0"
Return(Ans)
End
----------------------------
It is not working Please let me know why

chulett · Post by **chulett** » Mon May 21, 2007 6:34 am

Since you've started a new thread for this, answers are over there. I still don't understand why you continue down this path when you've been told several times it is completely unnecessary. At least for the reason you've given.

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 6:47 am

I agree with you
But I have to convince my Lead that we can connect to a 64 bit server using a 32 bit DSjob

chulett · Post by **chulett** » Mon May 21, 2007 6:52 am

Then just do it. Correct your dsenv file so that the 32bit libraries are used for the connection, you'll be fine.