04-04-2017
How to check the datatypes of the columns are same through shell scripting?
Hi,
We have a requirement like, to check the datatypes of columns against database.
After loading the sample data in to one of the database, need to compare the datatypes of the columns are matching with the provided files.
Is there a way that we can achieve through shell scripting.
We are using Netezza as database.
Any help/inputs are really appreciated.
Thanks in advance.
Samah
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
2. UNIX for Dummies Questions & Answers
Dear Champs,
Can anybody help me out to write a shell script , which will check whether the process is running , if running then divide the process into 2 so that next var it can take process parallel .
Let
ps -ef | grep a.sh => shows running
note a.sh will take a process of next... (0 Replies)
Discussion started by: manas_ranjan
0 Replies
3. Solaris
Hi,
I have a script which will check the fiel existence, the lines are as below
if !(test -d ./data) then
mkdir data
fi
In the first line error occurs as below
generatelicense.sh: syntax error at line 2: `!' unexpected
Where as this script works fine in linux OS.
How to solve... (2 Replies)
Discussion started by: krevathi1912
2 Replies
4. Shell Programming and Scripting
I am trying to write a script to get all the html files under a source directory and and for each html file, run a program with html file as an argument. This program generates an output which I need to save as htmlfilename.txt ( right now i was trying to print it on the command line)
... (11 Replies)
Discussion started by: sapient
11 Replies
5. Shell Programming and Scripting
I've got the following data in a file - basically hundred of passes.
Pass Id : PASSID1
Pass Name : 7 day pass 10 Gb
Pass Group : uk
Short Name : pmbbrh2
type : restrict
Validity ... (7 Replies)
Discussion started by: jeffersno1
7 Replies
6. Shell Programming and Scripting
Hi, I'm new to C Shell programming. I'm trying to check if a sym link exists on remote server if not send email. I'm not having much luck. Can anyone help?
Here is what I have written but it doesn't work. It tells me that my variable was not defined. Here is part of the script, the second... (0 Replies)
Discussion started by: CDi
0 Replies
7. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
8. Shell Programming and Scripting
I have two input files 1)datafile 2)metadata file.
I have a metadata file like:
field1datatypeformat1number2string3dateyy-mm-dd
I have a data file like:
1234abc12-8-16 xyz234512-9-163456acd14-08-12
In the first row there is no correction as everything is inline with the metadata.... (3 Replies)
Discussion started by: bikky6
3 Replies
9. Shell Programming and Scripting
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies
10. Shell Programming and Scripting
Hi ,
I have written a shell script to call a java program say load_id.sh .This sh script indeed is executed implicitly in other sh script which calls 2 more sh scripts one by one. I need to check if the load_id.sh (which calls java program) is executed successfully only then continue with... (1 Reply)
Discussion started by: preema
1 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::nobindvars
DBIx::Class::Storage::DBI::NoBindVars(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::NoBindVars(3)
NAME
DBIx::Class::Storage::DBI::NoBindVars - Sometime DBDs have poor to no support for bind variables
DESCRIPTION
This class allows queries to work when the DBD or underlying library does not support the usual "?" placeholders, or at least doesn't
support them very well, as is the case with DBD::Sybase
METHODS
connect_info
We can't cache very effectively without bind variables, so force the "disable_sth_caching" setting to be turned on when the connect info is
set.
_prep_for_execute
Manually subs in the values for the usual "?" placeholders.
interpolate_unquoted
This method is called by "_prep_for_execute" for every column in order to determine if its value should be quoted or not. The arguments are
the current column data type and the actual bind value. The return value is interpreted as: true - do not quote, false - do quote. You
should override this in you Storage::DBI::<database> subclass, if your RDBMS does not like quotes around certain datatypes (e.g. Sybase and
integer columns). The default method returns false, except for integer datatypes paired with values containing nothing but digits.
WARNING!!!
Always validate that the bind-value is valid for the current datatype.
Otherwise you may very well open the door to SQL injection attacks.
_prep_interpolated_value
Given a datatype and the value to be inserted directly into a SQL query, returns the necessary string to represent that value (by e.g.
adding a '$' sign)
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::NoBindVars(3)