?
Solved

A simple one

Posted on 2003-03-19
6
Medium Priority
?
1,957 Views
Last Modified: 2009-04-01
Can anybody tell me what object type *SQLPKG is ??
0
Comment
Question by:theo kouwenhoven
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 

Expert Comment

by:Misc_Knowledge
ID: 8168331
On the AS/400, *SQLPKG is an object type.
0
 
LVL 16

Author Comment

by:theo kouwenhoven
ID: 8170274
Yes I know, an object type of the type *SQLPKG meaning SQL package, but what the ..... is an SQL package:
- Where are they come from
- What does it do
- How to create
- What can I do with it
- Why do I want to have a SQL Package



0
 
LVL 33

Expert Comment

by:shalomc
ID: 8172960
An object of type *SQLPKG is created and used when your application uses data from remote databases.

This object is placed on the remote system to manage the connection and the data exchange.

Note: It is not necessary to use SQL packages for a distributed application to work, but the are benefits...

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/sqlp/rbafymstpack1.htm

0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 16

Author Comment

by:theo kouwenhoven
ID: 8179942
Hmmm, a little poor info on that link.

Is there some example to find (I double the points)
0
 
LVL 33

Accepted Solution

by:
shalomc earned 240 total points
ID: 8203027
Well, suppose you have 2 databases, let's put them on different servers.
You have an RPG (or any other supported language) program on systemA which should access the database on systemB.
You have 2 options:

A. In your SQLRPG program, use an explicit CONNECT statement, like this:
 CONNECT TO SYSTEMB USER murphey2 USING 'password'

and then run your SQL as usual, only now it will execute on systemB.

B. Write a regular SQLRPG program, but during compilation provide it with specific instructions to create a SQL package on the remote systemB:
CRTSQLRPG PGM(MYLIBO/PROGRAMA)  
          SRCFILE(MYLIBS/QRPGSRC)
          RDB(SYSTEMB)          
          USER(MURPHEY2)        
          PASSWORD('password')  
          SQLPKG(*PGM)          

This compilation will create a *PGM object on your systemA, and a *SQLPKG object on systemB.

At runtime, the local program will connect to the remote database via the SQL package for optimized results.

0
 
LVL 16

Author Comment

by:theo kouwenhoven
ID: 8203414
Great Thanks !!!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introducing Priority Question, our latest feature.
The Summer 2017 Scholarship Winners have been announced!
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question