03-16-2005
Thanks
Hi tmarikle,
Thanks a lot for your input. Now i am using dat file instead of piping. The maximum available buffer size for piping causes the issue and now i write to a file and then give that file as input to the sqlldr. Please find below the code.
Before:
$rc = 0xfff & system ("echo \"$if_admin\"|$ORACLE_HOME/bin/sqlldr userid=$USER/$PASSWD control=cfg/IF_ADMIN.ctl bad=/dev/null discard=/dev/null log=$LOGDIR/$interface.int.log > /dev/null");
After:
$rc = 0xfff & system("$ORACLE_HOME/bin/sqlldr userid=$USER/$PASSWD data=$LOGDIR/myAdmin.log control=cfg/IF_ADMIN.ctl bad=/dev/null discard=/dev/null log=$LOGDIR/$interface.int.log > /dev/null");
I use myAdmin.log as the input file to sqlldr.
Thanks,
Jai
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
When I try to format a slice in Solaris 10 I get the follow error :confused: :
-bash-3.00# mkfs /dev/dsk/c1d0s5 18877824
Can not determine partition size: Inappropriate ioctl for device
Some format command output:....
AVAILABLE DISK SELECTIONS:
0. c1d0 <DEFAULT cyl 38735 alt 2... (0 Replies)
Discussion started by: spoonman
0 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I have a cron entry:
59 23 * * * . $HOME/.profile;mydate=`date '+%Y%m%d'`;mv filename filename_$mydate
Which works fine interactively, but gives me the following error when it runs in cron:
Your "cron" job on servername
. $HOME/.profile;mydate=`date '+
produced the... (4 Replies)
Discussion started by: steelrose
4 Replies
3. Solaris
When I try to format a slice in Solaris 10 I get the follow error :
-bash-3.00# mkfs /dev/dsk/c1d0s5 18877824
Can not determine partition size: Inappropriate ioctl for device
Some format command output:....
AVAILABLE DISK SELECTIONS:
0. c1d0 <DEFAULT cyl 38735 alt 2 hd 64 sec 63>... (2 Replies)
Discussion started by: spoonman
2 Replies
4. Shell Programming and Scripting
Dear all,
Problem goes like this:
I have a shell script which when run manually runs perfectly.
When same script is executed through a job schdeduler I get an error as Inappropriate ioctl for device and the script fails.
This problems seems quite guiling to me.
Any clues are heartly... (11 Replies)
Discussion started by: RishiPahuja
11 Replies
5. UNIX for Dummies Questions & Answers
Hello guys,
on my Red Hat machine the /bin/mt status command gives the output dev/tape: inappropriate ioctl for device. This messages comes up after the Server has been rebooted.
Anybody an idea?
Thx
masterofdesaster (8 Replies)
Discussion started by: masterofdesaste
8 Replies
6. Shell Programming and Scripting
Hi All,
Am finding performance of my SD card using hdparm.
Code:
hdparm -tT /dev/BlockDev0
/dev/BlockDev0:
Timing cached reads: 1118 MB in 2.00 seconds = 558.61 MB/sec
HDIO_DRIVE_CMD(null) (wait for flush complete) failed: Inappropriate
ioctl for device
Timing buffered disk... (1 Reply)
Discussion started by: amio
1 Replies
7. Shell Programming and Scripting
Hello everyone
I am finishing a script allowing me to purge logs on multiple servers, i have one last pb with the ssh command.........it is throwing me the following error :
tcgetattr: Inappropriate ioctl for device (full screen in attached file 1, full script in attached file 2)
It... (15 Replies)
Discussion started by: jimmy75_13
15 Replies
8. UNIX for Advanced & Expert Users
Hi!
I am getting a nohup issue on mac osx while trying to start a process through nohup in the startup script.
nohup: can't detach from console: Inappropriate ioctl for device
Please help!
Thanks,
Allan. (0 Replies)
Discussion started by: jacki
0 Replies
9. UNIX for Dummies Questions & Answers
Hi,
ssh -q -t -l $usr $host bin/test.sh
I am using above command to run script remotely. script is working without any issues. but I am getting "tcgetattr: Inappropriate ioctl for device" message on console.
plz help how can I avoid this message.
Thanks
Moved thread from Emergency... (1 Reply)
Discussion started by: Kri
1 Replies
10. Shell Programming and Scripting
Sample program tty, this will be get called from my script test_script.
#include <stdio.h>
#include <unistd.h>
#define TTY_NAME_MAX 32
#define STDIN_FILENO 0 /* Standard input. */
int main(void) {
int ret = 0;
char local_device_file;
printf("\npid =... (7 Replies)
Discussion started by: Gajendra_PH
7 Replies
LEARN ABOUT DEBIAN
dbix::class::schema::loader::dbi::interbase
DBIx::Class::Schema::Loader::DBI::InterBase(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::InterBase(3pm)
NAME
DBIx::Class::Schema::Loader::DBI::InterBase - DBIx::Class::Schema::Loader::DBI Firebird Implementation.
DESCRIPTION
See DBIx::Class::Schema::Loader and DBIx::Class::Schema::Loader::Base.
COLUMN NAME CASE ISSUES
By default column names from unquoted DDL will be generated in lowercase, for consistency with other backends.
Set the preserve_case option to true if you would like to have column names in the internal case, which is uppercase for DDL that uses
unquoted identifiers.
Do not use quoting (the quote_char option in connect_info when in the default "preserve_case => 0" mode.
Be careful to also not use any SQL reserved words in your DDL.
This will generate lowercase column names (as opposed to the actual uppercase names) in your Result classes that will only work with
quoting off.
Mixed-case table and column names will be ignored when this option is on and will not work with quoting turned off.
SEE ALSO
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base, DBIx::Class::Schema::Loader::DBI
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-08 DBIx::Class::Schema::Loader::DBI::InterBase(3pm)