If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
@Tom
It may be unrelated to the question of newp, but considering am new to using SQL RPGLE, I would like to know where exactly does the table get created when we use CREATE TABLE command in the program? Does the table last till the job/program ends or till we issue a DROP TABLE command?
I would like to know where exactly does the table get created when we use CREATE TABLE command in the program? Does the table last till the job/program ends or till we issue a DROP TABLE command?
You can specify the library to create the table:
CREATE TABLE PGF.BILLOFMATERIAL
This creates table BillOfMaterial in library PGF.
The table remains until you drop it. If you want it to automatically be deleted at the end of the job, then you can create it in library QTEMP.
from proramming point whats the differnce by using DDS or SQL to create a database?.
from programming there's absolutely no difference at all (unless your program is using SQL to access the table data, then SQL tables will perform better). the main thing is that DDS is no longer being enhanced while IBM is committed to continue to improve/enhance SQL. it's far better to use what is currently being enhanced vs. using a stagnant method JMO.
I'm not anti-social, I just don't like people -Tommy Holden
I still want to understand the structure on as400 technology
I am just in the begining , hope i will get the idea soon
what is the most unique feaure you see it in as400 which make it different than other systems
my suggestion is to a) get a good book/tutorial on the system or b) take a class or c) find a seminar or a local user group to help you learn. most of us here don't have the time to write a tutorial on the entire system, database, etc. especially when all of those are on the web. go to IBM's infocenter, tons of info there as well. google is your friend
I'm not anti-social, I just don't like people -Tommy Holden
ok thanks alot .
because of that people always like open sources .
i get also why only few ppl as400's experts. But how people will learn if their is no one have the ability to facilitate learning..
who said if you want to learn you have to pay thousands ,I think as400 forum is the best place to ask ..
ok thanks alot .
because of that people always like open sources .
i get also why only few ppl as400's experts. But how people will learn if their is no one have the ability to facilitate learning..
who said if you want to learn you have to pay thousands ,I think as400 forum is the best place to ask ..
IBMs infocenter is 100% free...
I'm not anti-social, I just don't like people -Tommy Holden
Comment