For Programmers: Free Programming Magazines  


Home > Archive > Cobol > October 2007 > MF DB2 Compilations









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MF DB2 Compilations
Steve Rainbird

2007-10-05, 6:55 pm

When I compile my programs against my schema on same machine I specify.

"DB2(BIND DB==<dbalias> validate==bind multi-nested ACCESS==XXXX)"

If this database is on a different machine what should I specify?

If I just specify the DBALIAS I get an error.

* 801-S ( 0)
** External Compiler Module message
** DB0009 MF DB2 Connect program reported error condition '30082'.This
** error prevents SQL processing from continuing - further EXEC SQL
** statements will be ignored.

Which says it needs a password. How can I give it a schema name and
password?

TIA


--
Steve



Steve Rainbird

2007-10-08, 7:56 am

"Steve Rainbird" <news.nospam@rainbird.me.nospam.uk> wrote in message
news:5mnbvuFee9e4U1@mid.individual.net...
> When I compile my programs against my schema on same machine I specify.
>
> "DB2(BIND DB==<dbalias> validate==bind multi-nested ACCESS==XXXX)"
>
> If this database is on a different machine what should I specify?
>
> If I just specify the DBALIAS I get an error.
>
> * 801-S ( 0)
> ** External Compiler Module message
> ** DB0009 MF DB2 Connect program reported error condition '30082'.This
> ** error prevents SQL processing from continuing - further EXEC SQL
> ** statements will be ignored.
>
> Which says it needs a password. How can I give it a schema name and
> password?
>
> TIA
>
>
> --
> Steve
>
>
>




Found it.

DB2(BIND DB==<dbalias> PASS=userid.pass validate==bind multi-nested
ACCESS==XXXX

--
Steve



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com