Return to DINIT27J.m CVS log

Up to [Coherent Logic Development] / freem_fileman

Annotation of freem_fileman/DINIT27J.m, revision 1.1.1.1

1.1       snw         1: DINIT27J       ;SFISC/DPC - ORACLE (FIXED FORMAT) FOREIGN FORMAT;2/26/93  10:59 AM
                      2:        ;;21.0;VA FileMan;;Dec 28, 1994
                      3:        ;Per VHA Directive 10-93-142, this routine should not be modified.
                      4:        F I=1:2 S X=$T(ENTRY+I) G:X="" ^DINIT27K S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
                      5:        Q
                      6: ENTRY  ;
                      7:        ;;^DIST(.44,.008,0)
                      8:        ;;=ORACLE (FIXED FORMAT)^^^^^1^1^255^1^^^1
                      9:        ;;^DIST(.44,.008,1)
                     10:        ;;=D ORACTL^DDXPLIB
                     11:        ;;^DIST(.44,.008,3,0)
                     12:        ;;=^^5^5^2930125^
                     13:        ;;^DIST(.44,.008,3,1,0)
                     14:        ;;=Use this format to export data to an Oracle table.  Data will be exported
                     15:        ;;^DIST(.44,.008,3,2,0)
                     16:        ;;=in fixed format.  The user will be prompted for the length of each field
                     17:        ;;^DIST(.44,.008,3,3,0)
                     18:        ;;=and the field name.  By default, the data will be imported into an Oracle
                     19:        ;;^DIST(.44,.008,3,4,0)
                     20:        ;;=table with the same name as the export template used to export the data.
                     21:        ;;^DIST(.44,.008,3,5,0)
                     22:        ;;=The field names should be the column_names in the Oracle table.
                     23:        ;;^DIST(.44,.008,4,0)
                     24:        ;;=^^14^14^2930125^
                     25:        ;;^DIST(.44,.008,4,1,0)
                     26:        ;;=This format produces a control file to be used with Oracle's SQL*LOADER
                     27:        ;;^DIST(.44,.008,4,2,0)
                     28:        ;;=utility to load data into a preexisting Oracle table.  The control file is
                     29:        ;;^DIST(.44,.008,4,3,0)
                     30:        ;;=complete as created, but you may edit the file to modify the import.  By
                     31:        ;;^DIST(.44,.008,4,4,0)
                     32:        ;;=default, the data will be imported into a table with the same name as that
                     33:        ;;^DIST(.44,.008,4,5,0)
                     34:        ;;=of the export template.  Spaces in the export template name will be
                     35:        ;;^DIST(.44,.008,4,6,0)
                     36:        ;;=converted to underscores (_). So, either that table must exist in your
                     37:        ;;^DIST(.44,.008,4,7,0)
                     38:        ;;=Oracle table_space with the columns specified when the export template was
                     39:        ;;^DIST(.44,.008,4,8,0)
                     40:        ;;=built or the exported file will need to be modified to show the correct
                     41:        ;;^DIST(.44,.008,4,9,0)
                     42:        ;;=table_name.  A minimum syntax for loading an export file named
                     43:        ;;^DIST(.44,.008,4,10,0)
                     44:        ;;=INTO_ORACLE.CTL would be:
                     45:        ;;^DIST(.44,.008,4,11,0)
                     46:        ;;=|TAB|
                     47:        ;;^DIST(.44,.008,4,12,0)
                     48:        ;;=       SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB|
                     49:        ;;^DIST(.44,.008,4,13,0)
                     50:        ;;= 
                     51:        ;;^DIST(.44,.008,4,14,0)
                     52:        ;;=Of course, other options are available.  Consult your Oracle documentation.
                     53:        ;;^DIST(.44,.008,5,0)
                     54:        ;;=^.441^^