Sponsored Content
Full Discussion: Analytic functions in Pro*c
Top Forums Programming Analytic functions in Pro*c Post 302201891 by quintet on Tuesday 3rd of June 2008 10:51:48 AM
Old 06-03-2008
Analytic functions in Pro*c

Hi All,

when I use the following analytic function in sql prompt, i am getting the result

count(emp_no) over (partition by emp_no )

/* select count(emp_no) over (partition by emp_no ) from temp */

but when i use the same analytic function in Pro*c i get the following error


Error at line 160, column 36 in file test.pc
count(emp_no) over (partition by emp_no)
...................................1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following:

, into, from,

Error at line 0, column 0 in file test.pc
PCC-F-02102, Fatal error while doing C preprocessing
rm: sef_msel.c: No such file or directory
make: The error code from the last command is 2.


Can you advice me how to use analytic function in Pro*c?

Thanks...
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

domain logon problem - FreeBSD PDC w/ win2k pro and winxp pro

this is the seventh problem i'm having with samba. for some reason, i cannot logon to the domain. i've created user accounts... and i was able to establish a connection between the samba server (my PDC) and my workstations by logging in as "root." however now when i try to logon it gives... (5 Replies)
Discussion started by: xyyz
5 Replies

2. Shell Programming and Scripting

Regarding functions

Hi, I have a function or script like this. show() { echo "Hi" } | tee -a log show This creates a logfile and prints Hi in it. Now when I try to do the same for sql like this: show() { sqlplus -s scott/tiger<<! select * from details; ! } | tee -a log show Then it gives me a... (2 Replies)
Discussion started by: sendhilmani
2 Replies

3. Shell Programming and Scripting

Use of functions

Hi my shell is tcsh can I have functions in my shell scripting? Is the below shell script correct. Can I have two functions and call one of them as required. ---------- echo "functions" f1 f1 () { echo "hello" } f2 () (1 Reply)
Discussion started by: amitrajvarma
1 Replies

4. UNIX for Dummies Questions & Answers

Help with functions

Hi, I am exploring with defining functions in my BASH shell scripts. However, I am bit confused about how to pass parameters to my functions. I was under the impression that you must do something like the following: Define a function called "sample_function": function sample_function {... (3 Replies)
Discussion started by: msb65
3 Replies

5. Shell Programming and Scripting

i think i need functions ?

Hi, im making a little script but need some help Code i have so far is read -p 'Bot Nickname:' ecnick read -p 'Bot Username:' ecusername read -p 'Bot Realname:' ecrealname read -p 'Your Email:' ecemail echo '' echo Your bots nickname is set to $ecnick echo Your bots username is set to... (2 Replies)
Discussion started by: Gemster
2 Replies

6. Programming

Functions

Hi All, Can any one help me. I am calling in a function2 with string as parameter from function1, the function1 gives 3 values. how i get the 3 values from funciton2 to function1. i have to give a return or something. thanks in advance. (2 Replies)
Discussion started by: uday.sena.m
2 Replies

7. Shell Programming and Scripting

How to execute functions or initiate functions as command line parameters for below requirement?

I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line if then... (8 Replies)
Discussion started by: saku
8 Replies

8. UNIX for Beginners Questions & Answers

Deleting unused kdb+ analytic files in RedHat

Hello guys :) I am new to using Unix and was hoping somebody could help me. Essentially, I am trying to clean out my database. For example, I have a directory filled with 100s of analytics and I want to know if they are used by any other analytics or if they are used by the front end user... (17 Replies)
Discussion started by: Michael37
17 Replies
partition(5)							File Formats Manual						      partition(5)

NAME
partition - display information about the Partition Command Line Interface SYNOPSIS
DESCRIPTION
This manpage gives a listing and brief description of the commands which are used to manage a partitionable system. | Command | Description -----------+---------------------------------------------------- cplxmodify | Modify an existing complex. | parconfig | Provides a recommended nPartition configuration. | parcreate | Create a new partition. | parmodify | Modify an existing partition. | parolrad | Activate and Deactivate cell online. | parstatus | Display partition and available resources informa- | tion for a partitionable system. | parremove | Remove an existing partition. | parunlock | Unlock the Stable Complex Configuration Data or | Partition Configuration Data. | fruled | Turn attention LEDs on/off for cells, cabinets and | I/O chassis. | frupower | Turn power on/off for cells and I/O chassis. AUTHOR
was developed by the Hewlett-Packard Company. SEE ALSO
fruled(1), parstatus(1), cplxmodify(1M), frupower(1M), parconfig(1M), parcreate(1M), parmgr(1M), parmodify(1M), parolrad(1M), par- remove(1M), parunlock(1M). on partition(5)
All times are GMT -4. The time now is 07:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy