| |
 |
|
| Computers Forum Index » Computer - Databases - Pick » Q Pointers (I think)... |
|
Page 1 of 1 |
|
| Author |
Message |
| Rick Smereka... |
 Posted: Wed Sep 09, 2009 12:18 am |
|
|
|
Guest
|
Hi,
Our D3 (NT/VME) production server has (among others) two accounts lets
call them 'production' and 'sql'. Most daily work is done with the
'production' account and the 'sql' account is used to serve up ODBC. The
'sql' account contains file definitions linked back to the 'production'
account for the data portion only. I am not able to determine how this
is done. It is not a 'Q' pointer as the MD item contains:
: CT MD CUSTOMER
001 D
002 $(mds):$(MD)/customer/customer
003 3
The dictionary portion of the file has a local dictionary in the 'sql'
account with the item names changed to accommodate SQL/ODBC rules (like
no dashes).
The files I am trying to set up in the 'sql' account are prior years
files of a current year file already set up in the 'sql' account.
What I need to set up is a number of prior year files whose data portion
is in the 'production' account but I want to use the dictionary from
the current year file which is already in place. That way, I don't need
many copies of the same dictionary.
Here are my questions:
1. How are the data files in the 'sql' account likely to be setup
currently based on the data being in the 'production' account but the
dictionary in the 'sql' account?
2. How do I set up these prior years files with the data portion in the
'production' account and the dictionary portion in the 'sql' account?
Many thanks in advance,
Rick Smereka
Pride Seeds |
|
|
| Back to top |
|
|
|
| Kevin Powick... |
| Posted: Wed Sep 09, 2009 12:20 am |
|
|
|
Guest
|
On Sep 8, 4:18 pm, Rick Smereka <rick_smer... at (no spam) yahoo.com> wrote:
Quote: Hi,
Our D3 (NT/VME) production server has (among others) two accounts lets
call them 'production' and 'sql'. Most daily work is done with the
'production' account and the 'sql' account is used to serve up ODBC. The
'sql' account contains file definitions linked back to the 'production'
account for the data portion only. I am not able to determine how this
is done. It is not a 'Q' pointer as the MD item contains:
: CT MD CUSTOMER
001 D
002 $(mds):$(MD)/customer/customer
003 3
The MD q-pointer points to the file dictionary. The dictionary
contains another pointer to identify the data portion.
Try the command: CT DICT CUSTOMER CUSTOMER
That will show you the pointer definition for the data portion of that
file. My guess is that you'll find a q-pointer back to your
Production account.
Quote: What I need to set up is a number of prior year files whose data portion
is in the 'production' account but I want to use the dictionary from
the current year file which is already in place. That way, I don't need
many copies of the same dictionary.
Here are my questions:
1. How are the data files in the 'sql' account likely to be setup
currently based on the data being in the 'production' account but the
dictionary in the 'sql' account?
Q-pointer in the dictionary of the file points to the data in the
production account
Quote: 2. How do I set up these prior years files with the data portion in the
'production' account and the dictionary portion in the 'sql' account?
A file may contain multiple data sections. In the production account,
create new data sections for the existing file. Example to create new
data sections for the CUSTOMER file for the years 2004-2006. using 7
as the file modulo
CREATE-FILE DATA CUSTOMER,2004 7
CREATE-FILE DATA CUSTOMER,2005 7
CREATE-FILE DATA CUSTOMER,2006 7
Now, I don't have access to my system, so I can't quite remember...
You MIGHT be able to reference those new data sections from your SQL
account with the existing dict setup without having to do anything
more than specify the data section you wish to list as follows:
LIST CUSTOMER,2005 NAME ADDRESS PHONE
However, I believe that you're first going to have to set up q-
pointers in the dict of CUSTOMER for the SQL account for each of those
data sections you set up in production.
Once done, you would still access them the same way from the SQL
account.
LIST CUSTOMER,2005 NAME ADDRESS PHONE
--
Kevin Powick |
|
|
| Back to top |
|
|
|
| Rick Smereka... |
| Posted: Wed Sep 09, 2009 6:06 pm |
|
|
|
Guest
|
Quote: The MD q-pointer points to the file dictionary. The dictionary
contains another pointer to identify the data portion.
Try the command: CT DICT CUSTOMER CUSTOMER
That will show you the pointer definition for the data portion of that
file. My guess is that you'll find a q-pointer back to your
Production account.
Kevin,
You were correct. There are q-pointers in the dictionary portions of the
files.
Quote: Q-pointer in the dictionary of the file points to the data in the
production account
Understood.
Quote: A file may contain multiple data sections. In the production account,
create new data sections for the existing file. Example to create new
data sections for the CUSTOMER file for the years 2004-2006. using 7
as the file modulo
CREATE-FILE DATA CUSTOMER,2004 7
CREATE-FILE DATA CUSTOMER,2005 7
CREATE-FILE DATA CUSTOMER,2006 7
Interesting but I don't think I want to mess around with the data
portion of the files in the production account.
I successfully completed this task with your help. I decided to create a
dictionary portion of each file in the sql account and then copy all the
items from the current year dictionary and then install the q-pointer.
Works like a charm.
Thanks for your advice,
Rick Smereka |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Mon Nov 23, 2009 8:51 pm
|
|