Search results for query: *

Hi, I have a filter and in it is the ApplyComparison function doing a simple query. => ApplyComparison("#0=(SELECT WEEK FROM WEEK_DATA WHERE CURRENT_WEEK = 'Y')", WEEK@ID) My problem is whenever I view the report through the Web or look at the print preview, the value of that particular...

Hi, Just want to ask if I lack anything on my script or cron job. When I issue the script on the command line it can execute it normally. But if I use the cron to run it, it fails. Below are the details of my cron and the contents of my script: 15 00 * * * /home/dce/bin/atmupdate atmupdate...

Hi, Does anybody know how to handle the FIN_WAIT states? The setup is my server is suppose to automatically revert back to LISTEN mode once it gets disconnected (or restarted). My problem is that there are instances that the port I am suppose to use is sometimes in FIN_WAIT1 or FIN_WAIT2...

Hi, Which programming language would you recommend to develop GUI apps for AIX 4.3.3, Motif or GTK? Is there an application like the Glade Interface Developer of Redhat to develop GUI apps for AIX? If there is, where can I download it? Thanks.

Hi, First of all although the printf works in a shell script, its usually used in a C program. Most of the time, the echo command is the one used to display data. Looking at your script, I believe you just need to separate the data in the your logs and put it into separate variables. You...

Thanks vb5prgrmr. It tried it and it worked perfectly.

Hi, How can I resize an image (scanned image) for printing so that it will fit in one page. Everytime I tried to print it, it always print it in large sizes. But when I tried printing it using the Photoeditor it fits in one page. Below are the lines I used to print the scanned doc...

Thanks bi & CBCGB....=) I was able to download SAMBA for AIX and set it up successfully.

Hi, Is there a way to view image files stored in unix from the Windows OS? If yes, how is it done? Thanks.

Hi, I just want to ask what is the recommended library to use in programming GUI applications running on X-windows (AIX). Is it Motiff or GTK? Thanks in advance.

Hi, I don't think there are other ways (not sure about this) of removing a primary key without recreating the table. Below are currently the functionalities of the ALTER TABLE command based on the HELP of the psql on ALTER TABLE: Command: ALTER TABLE Description: Modifies table...

Hi, i believe a null is represented by the characters '' e.g. #!/bin/ksh var=$1 case $var in 1) echo "YES";; 2) echo "NO";; '') echo "INCORRECT";; *) echo "NOPE";; esac good luck! br, raisin96

Hi, If you are embedding it in the C language, you could also used the '/* */' comments... e.g. EXEC SQL SELECT fname,lname /* SELECT .... */ INTO :hv_Fname,:hv_Lname FROM EMPLOYEE /* EMPLOYEE TABLE */ WHERE idno=:hv_IDNo; Good Luck!

Thanks to all. :) to jamisar-> sorry, i'm not familiar if 'raisin' is french or not...:)

Hi, Which is better, creating child processes through fork or using the Unix message queues???.... I'm developing under an Unix AIX system.... My program will be connected to different Bank Branches and process the transactions coming in...for now i'm using the fork function to create child...

Hi boaconstrictor, I think you have to pre-compile it with the ecpg command. Then compile it with the cc or gcc... Here is a sample of my makefile. ENV = /home/aevangel SRC1 = $(ENV)/source/Database/ INC = $(ENV)/include PGINC = /usr/include/pgsql LIB = /usr/lib/pgsql OBJ = $(ENV)/obj/ BIN =...

Thanks boaconstrictor. best regards, raisin96

hi babcia01, You'll just have to convert it to a number so that you could use the avg function. Assuming you have this table: Table "Test" Attribute | Type | Modifier -----------+--------------+---------- a | character(5) | If you try this statement: select...

Hi, Which is better using functions to execute SQL statements or Embedded SQL...??? I'm currently doing Embedded SQL in C in an AIX environment. Functions e.g. PreparedStatement ps = con.prepareStatement("SELECT img FROM images WHERE imgname=?"); ps.setString(1...

Thanks Leland123. I added an "EXEC SQL COMMIT WORK;" after calling my function and its now woking normally. Best regards.