source: FOIAVistA/trunk/r/VA_FILEMAN-ARJT-DI-DD-DM-DT-%DT-%RCR/DINIT27J.m@ 1071

Last change on this file since 1071 was 628, checked in by George Lilly, 15 years ago

initial load of FOIAVistA 6/30/08 version

File size: 2.2 KB
Line 
1DINIT27J ;SFISC/DPC-ORACLE (FIXED FORMAT) FOREIGN FORMAT ;2/26/93 10:59 AM
2 ;;22.0;VA FileMan;;Mar 30, 1999
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
6ENTRY ;
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^^
Note: See TracBrowser for help on using the repository browser.