topic Re: using When condition in sql control file in Operating System - Linux

using When condition in sql control file

Gyankr — Tue, 13 May 2008 08:24:15 GMT

Hi,
I am using a when condition for a number like
When empno=2
but i am getting an exception like --Expecting quoted string or hex identifier, found "2".

When i use "2" or '2' the records are not being loaded as empno is a number.

Please let me know how to go about this?

Regards,
Gyan

Re: using When condition in sql control file

Robin T. Slotten — Thu, 15 May 2008 12:44:31 GMT

A snippit of your code would help, but I'll take a stab at it.

If this is a shell script,
When is not a valid condition.

empno is not defined as a specific type.

#!/usr/bin/sh

set -x
typeset -i empno=2 #define var as integer

if [ $empno -eq 2 ];then
print "employee 2"
fi

while [ $empno -eq 2 ];do
print "employee 2"
empno=3
done
# end job

Rob...

Re: using When condition in sql control file

Gyankr — Thu, 15 May 2008 13:59:26 GMT

oops sorry forgot about it,its not about unix,it is sql loader concept.