Conference acadmy::tpas_notes

    Andy,

    What is happening is that there is no discount record on the TPAS$DB 
    for shipments from PAS to ZGO.  TPAS_CALC_TRNSFR_PRC first looks into 
    TPAS$DB if the DISCOUNT record is not found, it then looks into 
    TPAS$XCLDD_DB.

    When I try this same entry I get the error:
      %APPIX-F-DSCNTSELECTNOF, DISCOUNT_TABLE SQL Select transaction, No record
         found

    I then defined TPAS$XCLDD_DB to FOO.FOO. Re-ran TPAS_DEMOSITE and got the
    error:
           F %RDB-E-BAD_DB_HANDLE, invalid database handle

    Check your TPAS$XCLDD_DB to make sure it exists. Use the TPAS_XCLDD_RDB.SQL
    to create the database. This database should have been created with the
    VMSInstall, but it looks like you may have changed your logical that points
    to it or it has been deleted.

    Once the database is created a discount record can be added to 
    TPAS$XCLDD_DB by having a finance/tax person run TPAS$EXE:TPAS_XCLDD.EXE.
    This will allow them to add a discount for shipments from PAS to ZGO
    and notify Corporate Tax that this discount has been added.      

    If this does not work please let me know.
    Regards,
    Lois

    
    Hi Lois,
    
    I have tried your suggestion by creating a discount in TPAS$XCLDD_DB for 
    shipments from PAS to ZGO as follows.  I then re-ran my application to 
    create invoice but again I got the same error "F %RDB-E-BAD_DB_HANDLE, 
    invalid database handle".
    
    
    All TPAS databases are created and existed already:
    
    TPAS$ROOT:[DATA]
    
    TPAS.RDB;2             1541/1542     3-JUL-1995 03:01:45.74
    TPAS_NOR.RDB;1        46433/46434    3-JUL-1995 03:01:27.46
    TPAS_STKRM.RDB;2       1541/1542     3-JUL-1995 03:01:43.30
    TPAS_XCLDD.RDB;1       1301/1302    10-MAY-1995 12:13:23.38
    
    
    I understand your point that there is no discount record for shipment
    from PAS to ZGO.  Now I added discount in TPAS$XCLDD_DB but still TPAS
    cannot return MTP for me.
    
    
    Any other thing I am not doing correctly?
    
    
    
    
    Regards,
    Andy
    
    
      Added discount from PAS to ZGO 
      ------------------------------
    
     TPAS_XCLDD                                                 13-Jul-1995
      
            FROM Area Code :  PAS           TO Area Code  :  ZGO
            PART           PART             PART            PRODT
            CLASS : FR     BASIC : PCTAZ    VARTN : CA      TYPE : MAJ
    
      EFF. DT    EFF.END DT STD CST UPLFT  MLP DSCNT % NOR DSNCT %  RBILL
      DSCNT %
    
      13-Jul-95  13-Jul-99      1.00          .45        .30          .04
    
    
    
    
    
    
    
    
    
          DISCOUNT Record Inserted/Modified
          SUCCESSFULLY.......
    
    
    
    
    SQL> sel DSCNT_TRNSFR_PRC_AREA_FROM_CD, DSCNT_TRNSFR_PRC_AREA_TO_CD,
    DSCNT_MLP_DSCNT_PERCT from DISCOUNT_TABLE
    cont> where DSCNT_TRNSFR_PRC_AREA_FROM_CD='PAS';
     DSCNT_TRNSFR_PRC_AREA_FROM_CD   DSCNT_TRNSFR_PRC_AREA_TO_CD  
    DSCNT_MLP_DSCNT_PERCT
     PAS                             ZGO                                           
    0.45
    
    1 row selected
    
    

Andy,

  The  'F %RDB-E-BAD_DB_HANDLE'  error is caused because as far as the
 SQL code knows the 'TPAS$XCLDD_DB' does not exist.
 Some of the reasons this may be happening are the process that is running 
 the application:

	o Doesn't have the logical, TPAS$XCLDD_DB, defined.
	o The definition for TPAS$XCLDD_DB is incorrect.
	o The logical for TPAS$XCLDD_DB is not in any of the following
	  name tables:
	   	LNM$TPAS
		LNM$SYSTEM_TABLE
		LNM$GROUP
		LNM$JOB
		LNM$PROCESS_TABLE

 
 You said you added the record to TPAS_XCLDD.RDB, how did you do that ?
 Did you run TPAS_XCLDD.EXE from the same account that you are running the
 application that gives you this error ?

 Lois