|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
comparing the null values in the unix
Post 302166153 by Sathy153 on Monday 11th of February 2008 06:24:44 AM
02-11-2008
Need some more info..
(1) Check the value of "Acct_id" in procedure: dtstg.lkp_trd_acct_prc.
This is stored in your log $PathOfTempLstFile/TrdAcctSqlLog
exec dtstg.lkp_trd_acct_prc('$1','$2',$3,$4,$5,$6,:Acct_id,:curr_cfdc_parm_typ_cd,:curr_org_id);
print :Acct_id;
(2) Echo value of $AcctID after the below statement
AcctID=`cut -f1 $PathOfTempLstFile/TrdAcctSqlLog`
======
echo $AcctID
======
(3) Need to change the below.. you need to use $AcctID & based on
point(1) you need to change the condition
if [ AcctID = " "]--- iam getting the error in this line
Hope this helps
This is stored in your log $PathOfTempLstFile/TrdAcctSqlLog
exec dtstg.lkp_trd_acct_prc('$1','$2',$3,$4,$5,$6,:Acct_id,:curr_cfdc_parm_typ_cd,:curr_org_id);
print :Acct_id;
(2) Echo value of $AcctID after the below statement
AcctID=`cut -f1 $PathOfTempLstFile/TrdAcctSqlLog`
======
echo $AcctID
======
(3) Need to change the below.. you need to use $AcctID & based on
point(1) you need to change the condition
if [ AcctID = " "]--- iam getting the error in this line
Hope this helps
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I have a script where i will remove header and trailer record and ftp to another server.
I'm using the code:
latestfilename=`ls filename_* | tail -1`
echo "Latest filename = $latestfilename"
sed '1d;$d' $latestfilename > a.ftpedfile
I have an issue if input data is having null... (1 Reply)
Discussion started by: ammu
1 Replies
2. Shell Programming and Scripting
I have a huge file with 20 fileds in each record and each field is seperated by "|". If i want to get all the reocrds that have 18th or for that matter any filed as null how can i do it? Please let me know (3 Replies)
Discussion started by: dsravan
3 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have a file with 10 columns and get the required data for nine columns properly except 8th. In 8th column i have both NULL and NON NULL values...i.e
certain records have values for all the columns including 8th column and certain records have 8th column as NULL.My requisite is,without... (20 Replies)
Discussion started by: ganesh_248
20 Replies
4. UNIX for Advanced & Expert Users
Hi,
Can someone help me comparing Null values.
Scenario is as follows:
I have a variable which "cache_prd" which can have either some integer or nothing(Null)
if it is integer I have to again do some comparision but these comparisons give me this error:( "line 32: [: 95: unary operator... (3 Replies)
Discussion started by: Yagami
3 Replies
5. Shell Programming and Scripting
Hi
I have a file with the values
abc
res
set
kls
lmn
ops
i want to sort this file with the null values at the bottom of the file
OUTPUT should look like this
abc
kls
lmn
ops (6 Replies)
Discussion started by: vickyhere
6 Replies
6. Shell Programming and Scripting
Hello everyone
I am doing a join command. Obviously, before I need two files sorted first. ( Both files have headers and have about 2 million lines each one )
The problem is, one of the files has null values in the key to sort (which is the first filed ). For example I have the original... (4 Replies)
Discussion started by: viktor1985
4 Replies
7. Shell Programming and Scripting
Hi ,
I have below data with fixed with of 52 bytes having three columns value data.
01930 MA GLOUCESTER
02033
02025 COHASSET
01960 MA ... (3 Replies)
Discussion started by: sonu_pal
3 Replies
8. Shell Programming and Scripting
I am using below code to validate the source file,code working fine but if any column contains null value then below code throwing error actually it should not.how to customize the below code to handle null null values also.
When I run the script with below source data getting “date error”, as... (2 Replies)
Discussion started by: srivalli
2 Replies
9. Shell Programming and Scripting
hi,
I had a small question.I had a file from which i need to extract data.
I have written the below script to check if the file exists and if it exists extract requierd columns from the file.
IFILE=/home/home01/Report_1.csv
OFILE=/home/home01/name.csv.out1
if #Checks if file exists... (1 Reply)
Discussion started by: Vivekit82
1 Replies
10. Shell Programming and Scripting
Hi,
i have another issue:
i have three files:
FILE 1
ServiceEventHandler,
Processed,Percentage
5285337,100%
FILE 2
Wallet,
Processed,Percentage
5285337,100% (1 Reply)
Discussion started by: reignangel2003
1 Replies
LEARN ABOUT OPENSOLARIS
noecho
echo(3XCURSES) X/Open Curses Library Functions echo(3XCURSES) NAME
echo, noecho - enable/disable terminal echo SYNOPSIS
cc [ flag... ] file... -I /usr/xpg4/include -L /usr/xpg4/lib -R /usr/xpg4/lib -lcurses [ library... ] c89 [ flag... ] file... -lcurses [ library... ] #include <curses.h> int echo(void); int noecho(void); DESCRIPTION
The echo() function enables Echo mode for the current screen. The noecho() function disables Echo mode for the current screen. Initially, curses software echo mode is enabled and hardware echo mode of the tty driver is disabled. The echo() and noecho() functions control soft- ware echo only. Hardware echo must remain disabled for the duration of the application, else the behavior is undefined. RETURN VALUES
Upon successful completion, these functions return OK. Otherwise, they return ERR. ERRORS
No errors are defined. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ |MT-Level |Unsafe | +-----------------------------+-----------------------------+ SEE ALSO
getch(3XCURSES), getstr(3XCURSES), initscr(3XCURSES), libcurses(3XCURSES), scanw(3XCURSES), attributes(5), standards(5) SunOS 5.11 5 Jun 2002 echo(3XCURSES)