Sponsored Content
Top Forums Shell Programming and Scripting Replace sql with dynamic values Post 303007556 by Master_Mind on Friday 17th of November 2017 07:01:44 PM
Old 11-17-2017
Thanks Yoda,

I am struck in my function where the query formation gets duplicated. So struck over there.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Dynamic SQl in KSH

My requirement is to create a KSH to generate the SQL select statement in oracle with all the columns and optional where condition if given the table name as input to the program Have any of you worked with a similar requirement? Can you give me some inputs? Regards, Kousikan (2 Replies)
Discussion started by: kousikan
2 Replies

2. UNIX for Dummies Questions & Answers

Dynamic variable values

Bit of a newbie :D with regard to unix scripting and need some advice. Hopefully someone can help with the following: I have a predefined set of variables as follows: AAA_IP_ADD=1.1.1.1 BBB_IP_ADD=2.2.2.2 I have a funnction call which retrieves a value into $SUPPLIER which would be... (3 Replies)
Discussion started by: ronnie_uk
3 Replies

3. Shell Programming and Scripting

Extracting dynamic values

Hi, I am stuck with extracting values by combining 2 dynamically extracted values. The code goes like this #!/usr/bin/ksh ID1="abcd" i=1 #this is a dynamic value and keeps on changing b="ID" #this is static now i want the value of ID1 variable. like echo $b$i But echo... (1 Reply)
Discussion started by: chaitanyapn
1 Replies

4. Shell Programming and Scripting

Dynamic SQL for where clause

Hi, I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4 Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value. eg. where Field1=AAA eg. where Field1=AAA and Field2=BBB eg.... (1 Reply)
Discussion started by: TeSP
1 Replies

5. UNIX for Advanced & Expert Users

Sql dynamic table / dynamic inserts

I have a file that reads File (X.txt) Contents of record 1: rdrDESTINATION_ADDRESS (String) "91 971502573813" rdrDESTINATION_IMSI (String) "000000000000000" rdrORIGINATING_ADDRESS (String) "d0 movies" rdrORIGINATING_IMSI (String) "000000000000000" rdrTRAFFIC_EVENT_TIME... (0 Replies)
Discussion started by: magedfawzy
0 Replies

6. Shell Programming and Scripting

Dynamic SQL query based on shell script parameters

Hi, I need a script that will run a dynamic Oracle SQL. Dynamic meaning the SQL statement depends on the parameter. For instance, something like this: #!/bin/ksh -x # Set environment . /home/mine/set_vars sqlplus $LOGINID <<! >> /home/mine/log.txt select count(1) from $1 where... (2 Replies)
Discussion started by: laiko
2 Replies

7. Shell Programming and Scripting

Dynamic sql where contents

Hi all, I need to add the contents from a file into a sql stament in the where clause. file1: id 1 2 3 10 11 ... script should look like : select name from tab_user tus where tus.id in (1,2,3,10,11..) any ideas or suggetions will be appreciatte. (5 Replies)
Discussion started by: valigula
5 Replies

8. Shell Programming and Scripting

dynamic values in a row

hi i have an input file in which there are diffrent values for xxxx,yyyyyy,zzzzzzz how can i arrange the dynamic values of x,y&z in a row. input file: xxxxx 1 yyyyyy 4 yyyyyy 5 zzzzzzzz 7 yyyyyy 13 zzzzzzzz 7 zzzzzzzz 6 yyyyyy 14 yyyyyy 12 zzzzzzzz 4 yyyyyy 4 yyyyyy 5 yyyyyy 6... (6 Replies)
Discussion started by: dodasajan
6 Replies

9. Shell Programming and Scripting

Using dynamic arrays to extract the values

Hi all, We have requirement to generate load timing based on subject areas HOUSEHOLD, BANKING and TRADING. These values are stored in an array SUB_ARR SUB_ARR=("HOUSEHOLD" "BANKING" "TRADING") Based on indicator files produced while processing data for each type, we need to get the stats (using... (2 Replies)
Discussion started by: sanjaydubey2006
2 Replies

10. Linux

Shell Script to generate Dynamic Param file Using SQL Plus Quey

Hi All, Can anyone give me Shell script sample script to generate Param file by Reading Values from SQL Plus query and it should assign those values to variables like.. $$SChema_Name='ORCL' Thanks in Advance... Srav... (4 Replies)
Discussion started by: Sravana Kumar
4 Replies
XHPInputChinese_s(3X)													     XHPInputChinese_s(3X)

NAME
XHPInputChinese_s - map keysyms into Chinese_s characters. SYNOPSIS
int XHPInputChinese_s(display, keysym, modifiers, buffer_return, bytes_buffer, status_in_out) Display *display; KeySym *keysym; unsigned int modifiers; char *buffer_return; int bytes_buffer; XComposeStatus *status_in_out; DESCRIPTION
display Specifies the connection to the X server. keysym Specifies the keysym that is to be converted into a character. modifiers Specifies the modifiers to be applied to the keysym. buffer_return Returns the translated characters. bytes_buffer Specifies the length of the buffer. No more than bytes_buffer of translation are returned. status_in_out Specifies the XComposeStatus structure. XHPInputChinese_s will convert keysym into an ASCII character, if appropriate. It will also handle 16-bit input using NLIO. If the value pointed to by keysym is used by the NLIO server, that value will be changed to NoSymbol. It will use status_in_out to keep the state information necessary to control NLIO. This structure must contain null values before this routine is first invoked, and must remain unchanged between uses. This routine will also process the control modifier. XHPInputChinese_s will use /usr/lbin/X11/xc0input as the NLIO server. NLIO input will be invoked when the right extend char key is hit, and it will be terminated when the left extend char key is hit. If the appropriate server is not running it will be started when it is first invoked. Users of this routine may want to exec the NLIO server previous to it being started up when the invoke key is first struck. This can also be accomplished using XHPNlioctl. The keys used to invoke and terminate the NLIO server can also be changed using XHPNlioctl. This routine is intended to be used in conjunction with XHPConvertLookup XHPConvertLookup and XHPInputChinese_s are provided for backwards compatibility only; these routines will be discontinued in a future release of HP-UX. Users desiring the same capabilities as those provided by these routines should use XOpenIM, XCreateIC, and XmbLookupString. RETURN VALUE
The return value is the length of the string returned in buffer_return. ORIGIN
Hewlett-Packard Company SEE ALSO
XHPConvertLookup(3X), XHPNlioctl(3X) INTERNATIONAL SUPPORT
8-bit and 16-bit character data. X Version 11 Release 5 XHPInputChinese_s(3X)
All times are GMT -4. The time now is 02:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy