View previous topic :: View next topic
|
Author |
Message |
Manikandan K
New User
Joined: 29 Mar 2007 Posts: 12 Location: Tamilnadu
|
|
|
|
Do any one of you know about the function of DUP command in NOMAD language?
Manikandan K |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Did you see this in some code? If so, please post the code just before and just after the code where you found DUP.
It has been many years since i supported NOMAD (this is the product that provides similar functionality as FOCUS, right?). If i can see your code, it may trigger some hidden memory |
|
Back to top |
|
|
Manikandan K
New User
Joined: 29 Mar 2007 Posts: 12 Location: Tamilnadu
|
|
|
|
Dick,
please find the code below
DEFINE PRINT_CODE(0) AS A6 = IF ALL((PRODUCT_INDEX) EQ &NAV)
THEN 'NSEL' ELSE USG_INQ_SVCS(PRODUCT_INDEX);
:
:
:
SELECT ALL((USG_INQ_SVCS) NE 'NSEL');
CREATE BY PRINT_AGR_NBR DUP
BY PRINT_CUST_NBR DUP
BY PRINT_SUB_NBR DUP
BY PRINT_CO_NAME DUP
BY PRINT_DUNS DUP
BY PRINT_SIC DUP
BY PRINT_OPER_ID DUP
BY USG_INQ_MEDIA DUP
BY INQUIRY_DATE DUP
BY INQUIRY_TIME DUP
BY TRANS_DATE DUP
BY USG_INQ_CHG DUP
BY PRINT_CODE DUP
ON USGTEMP KEEP;
is the select command used here is similar SQL or it is different?
also please explain me on DUP with the help of above CODES
Thanks in Advance,
Manikandan K |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If my memory is working this morning (really has been a while and i've no doc anymore), the DUP tells NOMAD to repeat the data if it duplicates data from the previous CREATE.
The SELECT in NOMAD is not exactly the same as an SQL select.
In many situations, the "key" fields are suppressed until a key change. Then the value is shown again - something like:
Code: |
(without DUP)
AGR_NBR CUST_NBR AMT
1111 1010 100.00
200.00
2020 123.00
200.00
2222 2313 100.00
4567 200.00 |
When creating a file, the suppression is usually not wanted:
:
Code: |
(with DUP)
AGR_NBR CUST_NBR AMT
1111 1010 100.00
1111 1010 200.00
1111 2020 123.00
1111 2020 200.00
2222 2313 100.00
2222 4567 200.00 |
Hopefully, i've remembered correctly - if not my bad. . .
If you are going to work with NOMAD, you might want to contact Select Business Solutions (the current vendor - NOMAD changed hands several times) to get the documentation. Their web site is
http://www.selectbs.com/ |
|
Back to top |
|
|
Manikandan K
New User
Joined: 29 Mar 2007 Posts: 12 Location: Tamilnadu
|
|
|
|
Thanks Dick. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome |
|
Back to top |
|
|
|