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
dkio(4) 						     Kernel Interfaces Manual							   dkio(4)

Name
       dkio - disk interface

Syntax
       #include <sys/fs.h>
       #include <sys/ioctl.h>

Description
       This  section  describes  the ioctl (input/output controller) codes for all disk drivers.  The basic ioctl (input/output controller) format
       is:

       #include <sys/fs.h>
       #include <sys/ioctl.h>
       ioctl(fildes, code, arg)
       struct pt *arg;

       The applicable codes are:

       DIOCGETPT       Indicates to the driver to store the information in the current partition table in the address pointed to by arg.  The file
		       descriptor must be opened on the raw partitions, a or c.

		       DIOCGETPT does not change the partition table, but it does provide access to the partition table information.

       DIOCSETPT       Indicates to the driver to modify the current partition table with the information pointed to by arg.

		       The file descriptor must be opened on the raw partitions, a or c.

		       If  the a or c partition is not mounted, only the partition table in the driver is modified.  This temporarily modifies the
		       partition table of the disk.  The modifications are overwritten with the default table when the disk is turned off and on.

		       If the a or c partition is mounted, both the partition table  in  the  driver  and  the	partition  table  in  the  primary
		       superblock are modified.  This permanently modifies the partition table of the disk.  This is not recommended.  To change a
		       partition table permanently, use the command.

       DIOCDGTPT       Indicates to the driver to store the default information of the current partition table in the address pointed to  by  arg.
		       The file descriptor must be opened on the raw partitions a or c.

		       DIOCGETPT does not change the partition table, but it does provide access to the partition table information.

       DKIOCGET        Allows the user to receive generic disk information as defined in structdevget.

       DKIOCACC        This code is defined in It is currently unused.

Restrictions
       These restrictions apply when using the DIOCSETPT ioctl code:

       o   You must have superuser privileges.

       o   You	cannot	shrink	or change the offset of a partition with a file system mounted on it or with an open file descriptor on the entire
	   partition.

       o   You cannot change the offset of the a partition.

Examples
       This example shows how to use the DIOGETPT ioctl code to print the length and offset of the a partition of an RZ23 disk:
       #include <sys/types.h>
       #include <sys/param.h>
       #include <sys/fs.h>
       #include <sys/ioctl.h>

       main()
       {
	    struct pt arg;
	    int fd, i;

	    /* Open the "a" partition of the disk you want to see */

	    if ( (fd = open("/dev/rz0a",0)) < 0 ) {
		 printf("Unable to open device
");
		 exit(2);
	    }

	    /* Get the partition information */

	    if ( ioctl(fd,DIOCGETPT,&arg) < 0 )
		 printf("Error in ioctl
");

	    printf("Length		Offset
");

	    for ( i = 0; i <= 7; i++ ) {
		 printf("%d		%d
",arg.pt_part[i].pi_nblocks,
			     arg.pt_part[i].pi_blkoff );
	    }
       }

Files
See Also
       rz(4), disktab(5), fstab(5), chpt(8), diskpart(8), fsck(8), MAKEDEV(8), mkfs(8), tunefs(8)

								       RISC								   dkio(4)
All times are GMT -4. The time now is 06:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy