is not an identifier error Post: 302429774

Sponsored Content

Top Forums Shell Programming and Scripting is not an identifier error Post 302429774 by svajhala on Tuesday 15th of June 2010 01:23:14 PM

06-15-2010

Registered User

is not an identifier error

Hi gurus,

I am trying to execute a shell script which connects to the oracle db and get the values from a table and then it exports the values on UNIX. For this, I am creating a temp file which stores the values returned from the select query and then executes this file. Below is the code which does this operation.

Code:

SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET TIMING OFF
SET TERMOUT OFF
SET LINES 160
SPOOL ${TmpFile}
    SELECT 'export DBName='||SUBSTR(source_table_name,1,INSTR(source_table_name,'.' )-1  )|| ';' FROM  DW_JOB_STREAMS WHERE JOB_STREAM_ID = '${JobStreamId}'
    UNION SELECT 'export src_tbl_name='||SUBSTR(source_table_name,INSTR(source_table_name,'.' )+1  )|| ';' FROM  DW_JOB_STREAMS WHERE JOB_STREAM_ID = '${JobStreamId}'
    UNION SELECT 'export LastExtractDate=' ||''''|| TO_CHAR(LAST_EXTRACT_DATE, 'MM/DD/YYYY HH12:MI:SS' )  ||''''|| ';' FROM  DW_JOB_STREAMS WHERE JOB_STREAM_ID = '${JobStreamId}'
    UNION SELECT 'export Access_User='||LOWER(ACCESS_USER)|| ';' FROM  DW_JOB_STREAMS WHERE JOB_STREAM_ID = '${JobStreamId}';
SPOOL OFF
exit
EOF`
       RC=$?
           if [ $RC -ne 0 ] ; then
               echo "$0: ERROR! while retrieving the Last Extract Date for JOB STREAM ID ${JobStreamId}."
              exit 1
          fi
       . ${TmpFile}

I am able to see the values correctly in TmpFile. But when it executes in UNIX, I am getting the below error only for a particular value which is LastExtractDate. The value in the db table for this column is 15/06/2010 12:31:00 PM. But when i execute the script, I get the below error:

Code:

export: 12:31:00';: is not an identifier

It is not recognizing the date part before the timestamp.

Can someone shed some light on this.

Thanks,

Last edited by Scott; 06-15-2010 at 02:29 PM.. Reason: Code tags, please...

svajhala

View Public Profile for svajhala

Find all posts by svajhala

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting is not an identifier error

Hi all, I am getting this error while setting CLASSPTH using a script my script is #!bin/ksh export CLASSPATH=$CLASSPATH:<some path>:<some path> If i do this thing on shell prompt individually it is working fine. but while using in shell script it is giving error. better if you...

2. Shell Programming and Scripting

': not a valid identifier

I am trying to write a bash script. I am able to do simple things like pass arguments, assign variables and echo the results. However, when I try to declare and array or anything a little more complicated I get ': not a valid identifier Here is my code so far: #!/bin/bash echo start t...

3. Solaris

-sh: is not an identifier

Hi , I am getting the following message when log into my unix account in sun solaris (version5.9)server. -sh: ORACLE_HOME=/apps/oracle/product/10.2.0/client_1: is not an identifier The ORACLE_HOME is set in .profile file. Another thing is that SID is also set inside .profile like...

4. Shell Programming and Scripting

not an identifier

Hi I have already gone through this topic on this forum, but still i am getting same problem. I am using solaris 10. my login shell is /usr/bash i have got a script as below /home/gyan> cat 3.cm #!/usr/bin/ksh export PROG_NAME=rpaa001 if i run this script as below , it works fine...

5. Shell Programming and Scripting

is not an identifier

Hi Guys... I am using the following codes in my script: SID_L=`cat /var/opt/oracle/oratab|grep -v "^#"|cut -f1 -d: -s` SID_VAR=$SID_L for SID_RUN in $SID_VAR do ORACLE_HOME=`grep ^$SID_RUN /var/opt/oracle/oratab | \ awk -F: '{print $2}'` ;export ORACLE_HOME export...

6. UNIX for Advanced & Expert Users

ORACLE_SID= ...: is not an identifier

Hello All, On My solaris 5.10 SPARC, i am always having problems setting my Oracle variables. even if it exists in the .profile file. below is an example $ export ORACLE_SID=test ORACLE_SID=test: is not an identifier even that the echo is returning the variable $ echo $ORACLE_SID...

7. Shell Programming and Scripting

Identifier issue

Hi, We are in the process of migrating our servers from Solaris to AIX. During our testing phase, while we are testing the scripts(reccnt.int), we are getting the following error during execution: /reccnt.int: a:fname:b:dte:tme:eqind:norecs:cntr:c:d:e:f: is not an identifier It is...

8. Shell Programming and Scripting

error while extracting a line from a file based on identifier

here is the content of input file CREATE TABLE `bla bla bla` ( `allianceSiteId` int(11) DEFAULT NULL, `trunkGroupsId` int(11) DEFAULT NULL, `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY `allianceSiteId`...

9. Solaris

Is not a identifier error

Hi I am trying to execute a script. I have solaris 10, After i login i will toggle to BASH. The script tried to set a variable called CARBON_HOME. Even i tried to set it manually. But still it is saying the following error.:wall: " CARBON_HOME=/usr/wso2/wso2esb-4.0.0: is not an...

10. UNIX for Dummies Questions & Answers

Compilation Error--Undeclared Identifier

Hello, I am trying to install BBFTP software on my Mac (OS X), and am running into some compilation errors. Here is the code, the specific errors are listed after: #include <dirent.h> #include <errno.h> #include <fnmatch.h> #include <netinet/in.h> #include <syslog.h> #include <sys/stat.h>...

LEARN ABOUT DEBIAN

set_constraints

SET 
CONSTRAINTS(7)						   SQL Commands 						SET CONSTRAINTS(7)

NAME

       SET CONSTRAINTS - set constraint checking modes for the current transaction

SYNOPSIS

       SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }

DESCRIPTION

       SET  CONSTRAINTS  sets  the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of
       each statement. DEFERRED constraints are not checked until transaction commit. Each constraint has its own IMMEDIATE or DEFERRED mode.

       Upon creation, a constraint is given one of three characteristics: DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY  IMMEDIATE,  or  NOT
       DEFERRABLE.  The  third	class  is  always  IMMEDIATE and is not affected by the SET CONSTRAINTS command. The first two classes start every
       transaction in the indicated mode, but their behavior can be changed within a transaction by SET CONSTRAINTS.

       SET CONSTRAINTS with a list of constraint names changes the mode of just those constraints (which must  all  be	deferrable).  The  current
       schema  search  path  is  used  to find the first matching name if no schema name is specified. SET CONSTRAINTS ALL changes the mode of all
       deferrable constraints.

       When SET CONSTRAINTS changes the mode of a constraint from DEFERRED to IMMEDIATE, the new mode takes effect retroactively: any  outstanding
       data  modifications  that  would  have  been checked at the end of the transaction are instead checked during the execution of the SET CON-
       STRAINTS command.  If any such constraint is violated, the SET CONSTRAINTS fails (and does not change the constraint mode). Thus, SET  CON-
       STRAINTS can be used to force checking of constraints to occur at a specific point in a transaction.

       Currently,  only  foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable.
       Triggers that are declared as ``constraint triggers'' are also affected.

NOTES

       This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside of a  trans-
       action block (BEGIN/COMMIT pair), it will not appear to have any effect.

COMPATIBILITY

       This command complies with the behavior defined in the SQL standard, except for the limitation that, in PostgreSQL, it only applies to for-
       eign-key constraints.

SQL - Language Statements					    2010-05-14							SET CONSTRAINTS(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting is not an identifier error

Discussion started by: swat

2. Shell Programming and Scripting

': not a valid identifier

Discussion started by: script123

3. Solaris

-sh: is not an identifier

Discussion started by: megh

4. Shell Programming and Scripting

not an identifier

Discussion started by: gyanibaba