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

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

initial load of FOIAVistA 6/30/08 version

File size: 2.2 KB
Line 
1DINIT27K ;SFISC/DPC-ORACLE (DELIMITED) FOREIGN FORMAT ;6/10/93 13:35
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="" ^DINIT28 S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
5 Q
6ENTRY ;
7 ;;^DIST(.44,.009,0)
8 ;;=ORACLE (DELIMITED)^,^^^^0^1^0^1^1^^1
9 ;;^DIST(.44,.009,1)
10 ;;=D ORACTL^DDXPLIB
11 ;;^DIST(.44,.009,3,0)
12 ;;=^^7^7^2930125^
13 ;;^DIST(.44,.009,3,1,0)
14 ;;=Use this format to export data to an Oracle table. Data will be exported
15 ;;^DIST(.44,.009,3,2,0)
16 ;;=in comma-delimited format and non-numeric fields will be surrounded by
17 ;;^DIST(.44,.009,3,3,0)
18 ;;=quotes. The user will be prompted for field names. The field names
19 ;;^DIST(.44,.009,3,4,0)
20 ;;=should be the column_names in the Oracle table. Also, the user will need
21 ;;^DIST(.44,.009,3,5,0)
22 ;;=to supply the maximum length of a record to be exported. By default, data
23 ;;^DIST(.44,.009,3,6,0)
24 ;;=will be imported into a table with the same name as that of the export
25 ;;^DIST(.44,.009,3,7,0)
26 ;;=template.
27 ;;^DIST(.44,.009,4,0)
28 ;;=^^13^13^2930125^
29 ;;^DIST(.44,.009,4,1,0)
30 ;;=This format produces a control file to be used with Oracle's SQL*LOADER
31 ;;^DIST(.44,.009,4,2,0)
32 ;;=utility to load data into a preexisting Oracle table. The control file is
33 ;;^DIST(.44,.009,4,3,0)
34 ;;=complete as created, but you may edit the file to modify the import. By
35 ;;^DIST(.44,.009,4,4,0)
36 ;;=default, the data will be imported into a table with the same name as that
37 ;;^DIST(.44,.009,4,5,0)
38 ;;=of the export template. So, either that table must exist in your Oracle
39 ;;^DIST(.44,.009,4,6,0)
40 ;;=table_space with the columns specified when the export template was built
41 ;;^DIST(.44,.009,4,7,0)
42 ;;=or the exported file will need to be modified to show the correct
43 ;;^DIST(.44,.009,4,8,0)
44 ;;=table_name. A minimum syntax for loading an export file named
45 ;;^DIST(.44,.009,4,9,0)
46 ;;=INTO_ORACLE.CTL would be:
47 ;;^DIST(.44,.009,4,10,0)
48 ;;= |TAB|
49 ;;^DIST(.44,.009,4,11,0)
50 ;;= SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB|
51 ;;^DIST(.44,.009,4,12,0)
52 ;;=
53 ;;^DIST(.44,.009,4,13,0)
54 ;;=Of course, other options are available. Consult your Oracle documentation.
55 ;;^DIST(.44,.009,5,0)
56 ;;=^.441^^
Note: See TracBrowser for help on using the repository browser.