10-25-2014
Can you post what you've done to solve this...
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Just wanted to know if there is a way to pass the table name as a parameter in the control file.
I have two tables...Table A and Table B.
LOAD DATA
append
INTO TABLE TABLE_B
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS
Rather than hard coding... (1 Reply)
Discussion started by: madhunk
1 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
3. HP-UX
Hi all,
I have to create table for each month inside a perl script.
tablename_monthnameyear.
megh_aug2008 for august 2008.
megh_sep2008 for september 2008.
just like the logfiles created on date basis.
thanks
megh (1 Reply)
Discussion started by: megh
1 Replies
4. Shell Programming and Scripting
Hey,
I want to create a table in bash, my db server is oracle. You can find my script below:
I am very confused. I tried to run this script many times without any luck. Please help! (6 Replies)
Discussion started by: radek
6 Replies
5. Shell Programming and Scripting
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Discussion started by: aimy
13 Replies
6. Shell Programming and Scripting
Hi Team,
I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
Table structure:
create multiset table tbl1, no fallback,
no before journal,
no after journal,
checksum = default,
default mergeblockratio... (7 Replies)
Discussion started by: unankix
7 Replies
7. Shell Programming and Scripting
Hello Frens,
I am a newbie to shell scripting. I need a help on creating a for loop script (shell script) for removing files. I have a table called a_table with column name fil_name which contains all the files that need to be removed.
Thank you in advance (6 Replies)
Discussion started by: manisha_singh
6 Replies
8. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
9. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT SUSE
unpost_menu
post(3MENU) post(3MENU)
NAME
post - write or erase menus from associated subwindows
SYNOPSIS
#include <menu.h>
int post_menu(MENU *menu);
int unpost_menu(MENU *menu);
DESCRIPTION
The function post_menu displays a menu to its associated subwindow. To trigger physical display of the subwindow, use refresh or some
equivalent curses routine (the implicit doupdate triggered by an curses input request will do). post_menu resets the selection status of
all items.
The function unpost_menu erases menu from its associated subwindow.
RETURN VALUE
These routines return one of the following:
E_OK The routine succeeded.
E_SYSTEM_ERROR
System error occurred (see errno).
E_BAD_ARGUMENT
Routine detected an incorrect or out-of-range argument.
E_POSTED
The menu has already been posted.
E_BAD_STATE
Routine was called from an initialization or termination function.
E_NO_ROOM
Menu is too large for its window. You should consider to use set_menu_format() to solve the problem.
E_NOT_POSTED
The menu has not been posted.
E_NOT_CONNECTED
No items are connected to the menu.
SEE ALSO
ncurses(3NCURSES), menu(3MENU).
NOTES
The header file <menu.h> automatically includes the header file <curses.h>.
PORTABILITY
These routines emulate the System V menu library. They were not supported on Version 7 or BSD versions.
AUTHORS
Juergen Pfeifer. Manual pages and adaptation for new curses by Eric S. Raymond.
post(3MENU)