DB2 Java SQLJ problem

Iris Foweather

DB2 Java SQLJ problem
I am trying to create and run my first SQLJ program in Windows NT. The data
is in DB2 V6.1 on OS/390 V2.10.

The commands I have run are:

sqlj -url=jdbc:db2:D2DC MyTest.sqlj
javac MyTest.java
profp MyTest_SJProfile0.ser
db2profc -user=username -password=password -url=jdbc:db2:D2DC
-prepoptions="bindfile using MyTest0.bnd package using MyTest0"
MyTest_SJProfile0.ser

which gives messages:
[IBM][SQLJ Driver] SQJ0001W Customizing profile "MyTest_SJProfile0".

[IBM][SQLJ Driver] SQJ0105E Unable to customize profile "MyTest_SJProfile0".

I cannot see where I have gone wrong (but as I said this is my first
attempt...). Please can anyone point me in the right direction?


Thanks,

Iris

Iris Foweather
Systems Programmer
Experian
Tel: 0115 9344312
Email : [login to unmask email]



=
Information in this e-mail and any attachments are confidential, and may
not be copied or used by anyone other than the addressee, nor disclosed
to any third party without our permission. There is no intention to
create any legally binding contract or other binding commitment through
the use of this electronic communication unless it is issued in accordance
with the Experian Limited standard terms and conditions of purchase or
other express written agreement between Experian Limited and the recipient
Experian Limited (registration number 653331) Registered office:
Talbot House, Talbot Street, Nottingham NG80 1TH

Although Experian has taken reasonable steps to ensure that this communication
and any attachments are free from computer virus, you are advised to take
your own steps to ensure that they are actually virus free.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Sanjay (Exchange) Jain

Re: DB2 Java SQLJ problem
(in response to Iris Foweather)
I am not sure what 'profp' command does. I suspect it is trying to customize
the .ser file. In that case you will have to specify -url, -user, -password
options as well. Try without the 'profp' command. That's what we do.

-----Original Message-----
From: Foweather, Iris [mailto:[login to unmask email]
Sent: Wednesday, December 17, 2003 10:46 AM
To: [login to unmask email]
Subject: DB2 Java SQLJ problem


I am trying to create and run my first SQLJ program in Windows NT. The data
is in DB2 V6.1 on OS/390 V2.10.

The commands I have run are:

sqlj -url=jdbc:db2:D2DC MyTest.sqlj
javac MyTest.java
profp MyTest_SJProfile0.ser
db2profc -user=username -password=password -url=jdbc:db2:D2DC
-prepoptions="bindfile using MyTest0.bnd package using MyTest0"
MyTest_SJProfile0.ser

which gives messages:
[IBM][SQLJ Driver] SQJ0001W Customizing profile "MyTest_SJProfile0".

[IBM][SQLJ Driver] SQJ0105E Unable to customize profile "MyTest_SJProfile0".

I cannot see where I have gone wrong (but as I said this is my first
attempt...). Please can anyone point me in the right direction?


Thanks,

Iris

Iris Foweather
Systems Programmer
Experian
Tel: 0115 9344312
Email : [login to unmask email]



=
Information in this e-mail and any attachments are confidential, and may
not be copied or used by anyone other than the addressee, nor disclosed
to any third party without our permission. There is no intention to
create any legally binding contract or other binding commitment through
the use of this electronic communication unless it is issued in accordance
with the Experian Limited standard terms and conditions of purchase or
other express written agreement between Experian Limited and the recipient
Experian Limited (registration number 653331) Registered office:
Talbot House, Talbot Street, Nottingham NG80 1TH

Although Experian has taken reasonable steps to ensure that this
communication
and any attachments are free from computer virus, you are advised to take
your own steps to ensure that they are actually virus free.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm