Dynamic Insert statement Post: 302330722

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk command for INSERT statement

Hi, I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this: INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL, PROPERTYNR) VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70) I...

2. Shell Programming and Scripting

Insert TAB in echo statement

Hi, Can some1 help me to output a tab in an echo statement. I have tried echo "RNC: \t NODEB" but dont get the correct output. I am a beginnger to unix, so pls hold back the laughs....if u can

3. Shell Programming and Scripting

Script does not execute Insert Statement

Hi I have a text file , contents are Line1:field1,field2,field3,field4,field5,field6.......field20 Line2:field1,field2,field3,field4,field5,field6.......field20 Line3:field1,field2,field3,field4,field5,field6.......field20 ....and so on... I want to read this file and insert the data into...

4. Shell Programming and Scripting

How is use sselect statement o/p in insert statement.

Hi All, I am using Unix ksh script. I need to insert values to a table using the o/p from a slelect statement. Can anybody Help! My script looks like tihs. ---`sqlplus -s username/password@SID << EOF set heading off set feedback off set pages 0 insert into ${TB_NAME}_D...

5. Shell Programming and Scripting

error in insert statement

hi, When i try to run the code below, i get the following error "ksh: syntax error: `(' unexpected" i am not able to figure it out. Can anyone help me? Code:

6. Shell Programming and Scripting

Creating a dynamic case statement

I'm using the korn shell and trying to create a case statement from the contents of a file that is changed regularly, each line of the file has three fields, eg track1 202.111.111.111 99 room7 222.111.222.333 76 I'm using awk to select each variable. I've been unable to figure out how to...

7. Programming

Assign variable for INSERT INTO statement

Hello, Can anyone tell me that, How can I assign variable to shell script variable, which i need to use in INSERT INTO statement? my shell script variables are, EMPNAME=`regular expression` EMPID=`regular expression` EMPBDATE=`regular expression` Now through ksh script I am...

8. Shell Programming and Scripting

How to insert numbers to a in between statement

Hi Guys, I want to create a shell script that will give me the output below. I want to insert the numbers from the input file to my url addresses below. And from the numbers below, I want to separate the last digit with a period (i.e. from 222222222222 to 22222222222.2). Appreciate any help....

9. Shell Programming and Scripting

How to insert date in a statement?

Hi Guys, Can somebody help me in inserting today's DATE format (20110709) in my awk statement. I have a script but its not working. inputfile.txt: 269,1,0,AAA,430 231,2,0,BBB,430 252,3,0,CCC,430 214,4,0,DDD,430 script.sh #!/bin/bash DATE="`date +%Y%m%d`" cd /var/opt/

10. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE...

LEARN ABOUT MOJAVE

glbindfragdatalocation

GLBINDFRAGDATALOCATI(3G)					    OpenGL 3.3						  GLBINDFRAGDATALOCATI(3G)

NAME

       glBindFragDataLocation - bind a user-defined varying out variable to a fragment shader color number

C SPECIFICATION

       void glBindFragDataLocation(GLuint program, GLuint colorNumber, const char * name);

PARAMETERS

       program
	   The name of the program containing varying out variable whose binding to modify

       colorNumber
	   The color number to bind the user-defined varying out variable to

       name
	   The name of the user-defined varying out variable whose binding to modify

DESCRIPTION

       glBindFragDataLocation explicitly specifies the binding of the user-defined varying out variable name to fragment shader color number
       colorNumber for program program. If name was bound previously, its assigned binding is replaced with colorNumber.  name must be a
       null-terminated string.	colorNumber must be less than GL_MAX_DRAW_BUFFERS.

       The bindings specified by glBindFragDataLocation have no effect until program is next linked. Bindings may be specified at any time after
       program has been created. Specifically, they may be specified before shader objects are attached to the program. Therefore, any name may be
       specified in name, including a name that is never used as a varying out variable in any fragment shader object. Names beginning with gl_
       are reserved by the GL.

       In addition to the errors generated by glBindFragDataLocation, the program program will fail to link if:

       o   The number of active outputs is greater than the value GL_MAX_DRAW_BUFFERS.

       o   More than one varying out variable is bound to the same color number.

NOTES

       Varying out varyings may have indexed locations assigned explicitly in the shader text using a location layout qualifier. If a shader
       statically assigns a location to a varying out variable in the shader text, that location is used and any location assigned with
       glBindFragDataLocation is ignored.

ERRORS

       GL_INVALID_VALUE is generated if colorNumber is greater than or equal to GL_MAX_DRAW_BUFFERS.

       GL_INVALID_OPERATION is generated if name starts with the reserved gl_ prefix.

       GL_INVALID_OPERATION is generated if program is not the name of a program object.

ASSOCIATED GETS

       glGetFragDataLocation() with a valid program object and the the name of a user-defined varying out variable

SEE ALSO

       glCreateProgram(), glGetFragDataLocation()

COPYRIGHT

       Copyright (C) 2010 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
       License, v 1.0, 8 June 1999.  http://opencontent.org/openpub/.

OpenGL 3.3							    03/08/2011						  GLBINDFRAGDATALOCATI(3G)