ConnectToDB2 routine

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 5:53 am

i have written a routine to connect to db2

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

--------------------------------------------------------------------------------

The Ans=1
Please let me know why is the routine not connecting to DB2

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2007 6:00 am

Code: Select all

Call DSLogWarn(ResultText, "Problem connecting")

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

In other words, you need to have the routine tell you what went wrong. Plus... Where is DBSCHEMA being used? What user/password is it connecting as?

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 8:51 am

Hi Craig
It would be very helpful if you could rewrite that routine for me

chulett · Post by **chulett** » Mon May 21, 2007 9:27 am

I'm sure it would. However, I don't know DB2 and don't have access to it in my environment. What did your DSLogInfo message show?

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 9:42 am

I have modified the routine to
Equate RoutineName To "ConnectToDB2"
Equate DBNAME TO Arg1
DB2CntCmd = "db2 CONNECT TO ":DBNAME
ResultText = @Null

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

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

If SystemReturnCode = 0 Then
Ans = "0"
Return(Ans)
End

This is returning the error as "Could not load the db2 program "

abhilashnair · Post by **abhilashnair** » Mon May 21, 2007 9:45 am

This is the complete error message

Result = Could not load program /db2t/gtstinsa/sqllib/bin/db2:
Could not load module /db2t/gtstinsa/sqllib/lib/libdb2.a(shr_64.o).
Dependent module /usr/opt/db2_08_01/lib/libdb2trcapi.a(shr_64.o) could not be loaded.
Member shr_64.o is not found in archive
Could not load module db2.
Dependent module /db2t/gtstinsa/sqllib/lib/libdb2.a(shr_64.o) could not be loaded.
Could not load module .

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2007 2:55 pm

Make sure the 32-bit libraries appear ahead of the 64-bit libraries in your shared library search path.

DSguru2B · Post by **DSguru2B** » Tue May 22, 2007 8:07 am

...which was advised in the very first place. And if you do that, then even your DB2 stage will work. No need for a routine.

chulett · Post by **chulett** » Tue May 22, 2007 8:26 am

It has been repeatedly advised.