| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I am currently working on a project that will use IBI/FOCUS on a Rdb data
base located on a remote node. When I run my test procedure, I get the
results shown below on the log. I have been unable to determine what the
problem is and would appreciate any help. This log reflects the execution
of the proceudre thru MRE;however, I get the same results when I use
IBI/FOCUS directly.
Thanks,
Carl
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
$ ON CONTROL_Y THEN LOGOUT
$ SET NOON
$ ! Restore VERIFY setting and split.
$ EXIT
$ IF F$MODE() .EQS. "BATCH" THEN GOTO MRELOG
$ MRELOG:
$!MRE LOGICALS
$ DEFINE/JOB IDB$$D_DML MKODEV::MRP5:[IDBDEV.MAS]
$ DEFINE/JOB IDB$$D_DAT MKODEV::MRP5:[IDBDEV.DAT]
$ DEFINE/JOB IDB$$D_EXE MKODEV::MRP5:[IDBDEV.EXE]
$ DEFINE/JOB DW$$D_DML NISYSH::$1$DJA34:[IDBTRAIN1.MAS]
$ DEFINE/JOB DW$$D_DAT NISYSH::$1$DJA34:[IDBTRAIN1.DAT]
$ DEFINE/JOB DW$$D_EXE NISYSH::$1$DJA34:[IDBTRAIN1.EXE]
$ Set NoVerify
--------------------------------------------------------------------------------
MRE background log file from your Office Machine for procedure: R
Unique name: TCCAH8EI.FEX
Node name: MAMIE
Time: 7-JUN-1990 07:20:17.54
--------------------------------------------------------------------------------
Generating report. Please wait...
> ERROR MESSAGE TEXT MISSING 110 : IDB
(FSTAT -1) FATAL DBMS ERROR, PROCEDURE ABORTED [DBERROR : 20480196]
%RDB-F-IO_ERROR, input or output error
-SYSTEM-F-INVLOGIN, login information invalid at remote node
%DELETE-W-SEARCHFAIL, error searching for USER9:[QUINONES.A1.541]%NOPARAMETER.FEX;*
-RMS-E-FNF, file not found
%DELETE-W-SEARCHFAIL, error searching for USER9:[QUINONES.A1.541]*.MAS;*
-RMS-E-FNF, file not found
QUINONES job terminated at 7-JUN-1990 07:21:41.50
Accounting information:
Buffered I/O count: 1065 Peak working set size: 2811
Direct I/O count: 242 Peak page file size: 11238
Page faults: 4054 Mounted volumes: 0
Charged CPU time: 0 00:00:05.96 Elapsed time: 0 00:01:30.91
-------------------------------------------------------------------------
-------------------------------------------------------------------------
$ Focus ACX (Cross Reference) for REVENUE
$ Generated by the Encyclopedia on
$ 6-Jun-1990 15:23:20.95
$
SEGNAME=HEADER ,
TABLENAME="IDB.ORDER_HEADER" ,
KEYS=,WRITE=NO,
$
FIELD=CUST_AUTH_CD, ALIAS=CUSTMR_PRCRMT_TYPE_CD , $
FIELD=DEC_NO , ALIAS=DEC_ORDER_NO , $
FIELD=GVT_250_IND , ALIAS=GOVT_DD250_DOCMT_REQMT_INDCR , $
FIELD=GVT_PRRTY_CD, ALIAS=GOVT_ORDER_PRRTY_RATG_CD , $
FIELD=MRKT_CD , ALIAS=MRKT_CD , $
FIELD=SOLDTO_CUST , ALIAS=SOLDTO_CUSTMR_ID , $
FIELD=GOVT_MKT_CD , ALIAS=USA_GOVT_MRKT_CD , $
FIELD=SLS_DIST_CD , ALIAS=USA_SLS_DSTRCT_CD , $
FIELD=SLS_RGN_CD , ALIAS=USA_SLS_RGN_CD , $
$
SEGNAME=CUSTOMER ,
TABLENAME="IDB.CUSTOMER" ,
KEYS=,WRITE=NO,
KEYFLD=SOLDTO_CUST,
IXFLD=CUSTMR_ID,
$
FIELD=CUSTMR_ID , ALIAS=CUSTMR_ID , $
FIELD=CUSTMR_NAME , ALIAS=CUSTMR_NAME , $
$
SEGNAME=ORDLINE ,
TABLENAME="IDB.ORDER_LINE" ,
KEYS=,WRITE=NO,
KEYFLD=DEC_NO,
IXFLD=DEC_NO02,
$
FIELD=LIN_CERT_DT , ALIAS=CUSTMR_ORDER_LNITM_CERTFN_DT , $
FIELD=DEC_NO02 , ALIAS=DEC_ORDER_NO , $
FIELD=LINE_SEG_CD , ALIAS=LINE_SEGMT_CD , $
FIELD=LINE_ALW_CTD, ALIAS=LNITM_ALLWNC_INVCD_TODT_AMT , $
FIELD=LIN_DISC_CTD, ALIAS=LNITM_INVCD_TODT_DSCNT_AMT , $
FIELD=LIN_LTST_SHP, ALIAS=LNITM_LATEST_SHPMT_DT , $
FIELD=LIN_QTY_SHPD, ALIAS=LNITM_QTY_SHPD_TODT , $
FIELD=ORD_LNITM_NO, ALIAS=ORDER_LNITM_NO , $
FIELD=PART_NO , ALIAS=PART_NO , $
FIELD=PRODT_PRC , ALIAS=PRODT_PRC , $
$
SEGNAME=SUBLINE ,
TABLENAME="IDB.ORDER_SUB_LINE" ,
KEYS=,WRITE=NO,
KEYFLD=DEC_NO02/ORD_LNITM_NO,
IXFLD=DEC_NO03/ORD_LNITM_02,
$
FIELD=DEC_NO03 , ALIAS=DEC_ORDER_NO , $
FIELD=ORD_LNITM_02, ALIAS=ORDER_LNITM_NO , $
FIELD=SUB_LTST_SHP, ALIAS=SUBLINE_LATEST_SHPMT_DT , $
FIELD=SUBLINE_NO , ALIAS=SUBLINE_NO , $
FIELD=SLN_QTY_SHPD, ALIAS=SUBLINE_QTY_SHPD_TODT , $
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
FILE=REVENUE , SUFFIX=RDB
$ Focus Master for REVENUE
$ Generated by the Encyclopedia on
$ 6-Jun-1990 15:23:20.95
$
$CSS REVENUE INFORMATION
$
$
SEGNAME=HEADER,SEGTYPE=S0,
$
FIELD=CUST_AUTH_CD, ALIAS= ,
USAGE =A2 ,
ACTUAL=A2 ,
TITLE='CUST,AUTH,CODE',$
$
$ BASED ON: CUSTMR_PRCRMT_TYPE_CD
$ DESC: REPRESENTS THE CUSTMR AUTHZN FOR ACCEPTANCE OF DEC PRODUCTS
$
FIELD=DEC_NO , ALIAS= ,
USAGE =A9 ,
ACTUAL=A9 ,
TITLE='DEC,ORDER,NUMBER',$
$
$ BASED ON: DEC_ORDER_NO
$ DESC: DIGITAL'S IDENTIFIER FOR A CUSTOMER ORDER
$
FIELD=GVT_250_IND , ALIAS= ,
USAGE =A1 ,
ACTUAL=A1 ,
TITLE='DD,250,IND',$
$
$ BASED ON: GOVT_DD250_DOCMT_REQMT_INDCR
$ DESC: INDICATES IF A DD250 DOCUMENT IS REQUIRED
$
FIELD=GVT_PRRTY_CD, ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='GOVT,PRTY,RATG',$
$
$ BASED ON: GOVT_ORDER_PRRTY_RATG_CD
$ DESC: PRIORITY RATING OF GOVERNMENT ORDERS
$
FIELD=MRKT_CD , ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='MKT,CODE',$
$
$ BASED ON: MRKT_CD
$ DESC: Classifies customer accounts by size and market
$
FIELD=SOLDTO_CUST , ALIAS= ,
USAGE =A7 ,
ACTUAL=A7 ,
TITLE='SOLDTO,CUSTMR',$
$
$ BASED ON: CUSTMR_ID
$ DESC: UNIQUE IDENTIFIER ASSIGNED TO A SOLDTO CUSTOMER BY DEC
$
FIELD=GOVT_MKT_CD , ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='GOVT,MRKT,CD',$
$
$ BASED ON: USA_GOVT_MRKT_CD
$ DESC: Digtal codes identifying US Govt orders.
$
FIELD=SLS_DIST_CD , ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='SALES,DIST',$
$
$ BASED ON: USA_SLS_DSTRCT_CD
$ DESC: Code for a Sales District in the United States.
$
FIELD=SLS_RGN_CD , ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='SALES,REGN',$
$
$ BASED ON: USA_SLS_RGN_CD
$ DESC: Code for a Sales Region in the United States.
$
$
SEGNAME=CUSTOMER,SEGTYPE=U ,
PARENT=HEADER,
$
FIELD=CUSTMR_ID , ALIAS= ,
USAGE =A7 ,
ACTUAL=A7 ,
TITLE='CUSTMR ID',$
$
$ BASED ON: CUSTMR_ID
$ DESC: UNIQUE IDENTIFIER ASSIGNED TO A CUSTOMER BY DEC
$
FIELD=CUSTMR_NAME , ALIAS= ,
USAGE =A35 ,
ACTUAL=A35 ,
TITLE='CUSTOMER NAME',$
$
$ BASED ON: CUSTMR_NAME
$ DESC: THE NAME ASSOCIATED WITH A CUSTOMER IDENTIFIER.
$
$
SEGNAME=ORDLINE,SEGTYPE=S0,
PARENT=HEADER,
$
FIELD=LIN_CERT_DT , ALIAS= ,
USAGE =A6 ,
ACTUAL=A6 ,
TITLE='LNITM,CERT,DATE',$
$
$ BASED ON: CUSTMR_ORDER_CERTFN_DT
$ DESC: THE DATE A LINE ITEM WAS ACCEPTED BY DIGITAL
$
FIELD=DEC_NO02 , ALIAS= ,
USAGE =A9 ,
ACTUAL=A9 ,
TITLE='DEC,ORDER,NUMBER',$
$
$ BASED ON: DEC_ORDER_NO
$ DESC: DIGITAL'S IDENTIFIER FOR A CUSTOMER ORDER
$
FIELD=LINE_SEG_CD , ALIAS= ,
USAGE =A3 ,
ACTUAL=A3 ,
TITLE='LINE,SEG',$
$
$ BASED ON: LINE_SEGMT_CD
$ DESC: Line item code identifying mrktg or service org. credited with
$
FIELD=LINE_ALW_CTD, ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='LNITM_ALLOW,INVCD_TODT',$
$
$ BASED ON: LNITM_ALLWNC_INVCD_TODT_AMT
$ DESC: Amount of line item allowance invoiced to date.
$
FIELD=LIN_DISC_CTD, ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='LNITM,DISC,TODT',$
$
$ BASED ON: LNITM_INVCD_TODT_DSCNT_AMT
$ DESC: Line item discount amount invoiced to date
$
FIELD=LIN_LTST_SHP, ALIAS= ,
USAGE =A6 ,
ACTUAL=A6 ,
TITLE='LNITM,LATEST,SHPMT',$
$
$ BASED ON: CUSTMR_ORDER_LATEST_SHPMT_DT
$ DESC: Date of latest shpmt against a custmr order line
$
FIELD=LIN_QTY_SHPD, ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='LNITM QTY,SHPD TODT',$
$
$ BASED ON: QTY_SHPD_TODT
$ DESC: # of line item units shipped to date.
$
FIELD=ORD_LNITM_NO, ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='LNITM,NO',$
$
$ BASED ON: LNITM_NO
$ DESC: NUMBER ASSIGNED TO A LINE ITEM ON AN ORDER
$
FIELD=PART_NO , ALIAS= ,
USAGE =A13 ,
ACTUAL=A13 ,
TITLE='PART NUMBER',$
$
$ BASED ON: PART_NO
$ DESC: Identifies a Digital part, product, or service.
$
FIELD=PRODT_PRC , ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='PRODT,PRICE',$
$
$ BASED ON: PRODT_PRC
$ DESC: PRODUCT SELLING PRICE
$
$
SEGNAME=SUBLINE,SEGTYPE=S0,
PARENT=ORDLINE,
$
FIELD=DEC_NO03 , ALIAS= ,
USAGE =A9 ,
ACTUAL=A9 ,
TITLE='DEC,ORDER,NUMBER',$
$
$ BASED ON: DEC_ORDER_NO
$ DESC: DIGITAL'S IDENTIFIER FOR A CUSTOMER ORDER
$
FIELD=ORD_LNITM_02, ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='LNITM,NO',$
$
$ BASED ON: LNITM_NO
$ DESC: NUMBER ASSIGNED TO A LINE ITEM ON AN ORDER
$
FIELD=SUB_LTST_SHP, ALIAS= ,
USAGE =A6 ,
ACTUAL=A6 ,
TITLE='SUBLINE,LATEST,SHPMT',$
$
$ BASED ON: CUSTMR_ORDER_LATEST_SHPMT_DT
$ DESC: Date of latest shpmt against a custmr order subline
$
FIELD=SUBLINE_NO , ALIAS= ,
USAGE =A4 ,
ACTUAL=A4 ,
TITLE='SUBLINE,ITEM NO',$
$
$ BASED ON: LNITM_NO
$ DESC: NUMBER ASSIGNED TO A SUBLINE ITEM ON A DOCUMENT
$
FIELD=SLN_QTY_SHPD, ALIAS= ,
USAGE =F18.2 ,
ACTUAL=F4 ,
TITLE='SUBLINE QTY,SHPD TODT',$
$
$ BASED ON: QTY_SHPD_TODT
$ DESC: # of sublines shipped to date.
$
| T.R | Title | User | Personal Name | Date | Lines |
|---|