Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Routine: DINIT27K

DINIT27K.m

Go to the documentation of this file.
  1. DINIT27K ;SFISC/DPC-ORACLE (DELIMITED) FOREIGN FORMAT ;6/10/93 13:35
  1. ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
  1. ;;Per VA Directive 6402, this routine should not be modified.
  1. ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
  1. ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
  1. ;;Licensed under the terms of the Apache License, Version 2.0.
  1. ;
  1. F I=1:2 S X=$T(ENTRY+I) G:X="" ^DINIT28 S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
  1. Q
  1. ENTRY ;
  1. ;;^DIST(.44,.009,0)
  1. ;;=ORACLE (DELIMITED)^,^^^^0^1^0^1^1^^1
  1. ;;^DIST(.44,.009,1)
  1. ;;=D ORACTL^DDXPLIB
  1. ;;^DIST(.44,.009,3,0)
  1. ;;=^^7^7^2930125^
  1. ;;^DIST(.44,.009,3,1,0)
  1. ;;=Use this format to export data to an Oracle table. Data will be exported
  1. ;;^DIST(.44,.009,3,2,0)
  1. ;;=in comma-delimited format and non-numeric fields will be surrounded by
  1. ;;^DIST(.44,.009,3,3,0)
  1. ;;=quotes. The user will be prompted for field names. The field names
  1. ;;^DIST(.44,.009,3,4,0)
  1. ;;=should be the column_names in the Oracle table. Also, the user will need
  1. ;;^DIST(.44,.009,3,5,0)
  1. ;;=to supply the maximum length of a record to be exported. By default, data
  1. ;;^DIST(.44,.009,3,6,0)
  1. ;;=will be imported into a table with the same name as that of the export
  1. ;;^DIST(.44,.009,3,7,0)
  1. ;;=template.
  1. ;;^DIST(.44,.009,4,0)
  1. ;;=^^13^13^2930125^
  1. ;;^DIST(.44,.009,4,1,0)
  1. ;;=This format produces a control file to be used with Oracle's SQL*LOADER
  1. ;;^DIST(.44,.009,4,2,0)
  1. ;;=utility to load data into a preexisting Oracle table. The control file is
  1. ;;^DIST(.44,.009,4,3,0)
  1. ;;=complete as created, but you may edit the file to modify the import. By
  1. ;;^DIST(.44,.009,4,4,0)
  1. ;;=default, the data will be imported into a table with the same name as that
  1. ;;^DIST(.44,.009,4,5,0)
  1. ;;=of the export template. So, either that table must exist in your Oracle
  1. ;;^DIST(.44,.009,4,6,0)
  1. ;;=table_space with the columns specified when the export template was built
  1. ;;^DIST(.44,.009,4,7,0)
  1. ;;=or the exported file will need to be modified to show the correct
  1. ;;^DIST(.44,.009,4,8,0)
  1. ;;=table_name. A minimum syntax for loading an export file named
  1. ;;^DIST(.44,.009,4,9,0)
  1. ;;=INTO_ORACLE.CTL would be:
  1. ;;^DIST(.44,.009,4,10,0)
  1. ;;= |TAB|
  1. ;;^DIST(.44,.009,4,11,0)
  1. ;;= SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB|
  1. ;;^DIST(.44,.009,4,12,0)
  1. ;;=
  1. ;;^DIST(.44,.009,4,13,0)
  1. ;;=Of course, other options are available. Consult your Oracle documentation.
  1. ;;^DIST(.44,.009,5,0)
  1. ;;=^.441^^