Search results for query: *

Hi, I've a date column, p_date. I need to get the minimum of p_date. Like in oracle I was trying the min(p_date) but came to know it returns the minimum of numerical value. Can anyone pls let me know how to get the min of _date ? Thanks....

Hi, Help using awk or sed... I've a text file which contains pipe delimited data like, 100|EQTX|EQUITY TAXABLE| 102|GTHTX|GROWTH TAXABLE| 105|CPRESTX|CAPITAL PRESER TAXABLE - PFM| 103|GINCTX|GROWTH & INCOME TAXABLE| After using sed or awk, I need an output file which just contains the...

Hi, I've a delete statement inside my unix shell script, which will delete around 8 million rows. Is there anyway that I can do frequent commits rather than doing commit after 8 million rows. I've set the autocommit option ON and the statement is given below, delete from table1 a where...

Hi, I've a query which creates an output with many columns. I want to transfer the whole query output to a new table.. The query output has some decimal values in the columns too which I want to have it the same...It should not get rounded... I just want to have the same values in the table...

Error: Operation must use an updatable query While running the below query, I'm getting the error, Operation must use an updatable query. UPDATE CapgComp_init AS A SET A.cl_id = (SELECT LEFT(B.cl_id, 4)&T.future_state_account_num FROM CapgComp_init B INNER JOIN current_future_acct_num AS T...

Hi, I've an output from a query like given below. I've to again manipulate the result to get another output. I've to compare the values in the first field with a column in another table,Table2. But the question is, I've to compare from the 4th position of the cl_id. Ex: I should check this...

Hi, Very new to MS-Access. I'm trying to format the date and get the min of date but its returning a wrong value. select min(Format(emp.emp_date-DatePart("d",emp_date),'mm/dd/yyyy')) AS emp_date from emp ; The values in the table are, 10/1/1992 11/1/1992 12/1/1992...

Hi, very new to MS-Access. Help pls. I'm creating an extract(.txt file) by running a select query on 2 tables swarc, swsr. One particular field (g_total) in the extract has to be retrieved upon a condition. The condition is, if swsr.id_1 is null then g_total should be...

Hi, I'm using a switch function in a select statement,and the query is SELECT ret_date as return_date, switch([dbarc.cat_cd]="TOTA","TOTAL", [dbarc.cat_cd]="TOTM","TOTM", [dbarc.cat_cd]="EQT","EQTALL", [dbarc.cat_cd]="FIX","FIXALL") AS class,'N'AS cash FROM...

Hi, Help needed with Switch function. Very much new to MS_Access. I've a column with datatype TEXT. It has got both numbers and text in it.I want to select the values from that column according to a condition. If the column values are < 100 I want to append with 22- . So it has to be...

Hi, Very much new to MS-Access and my first assignment in Access.I've got a couple of questions. I need to create an extract by selecting from multiple tables and put it in a flat file. In the case of Oracle we use to spool the output to a file. Is there anyway in Access we can do anything...

Hi, Pretty much new to MS-Access. Need help in, creating a extract file(.txt file) from the MS-Access database tables. Can you pls suggest a method for doing this ? ( I dont want to export the whole table to .txt file, I want to create a extract according to some conditions in the query )...

Hi, Can you pls help me to do a to_char on a number with format as 20 digits and 2 decimals. Is there a way to format without typing 9 twenty times. Thanks, RG select to_char(123345.67,'99999999999999999999D99' from dual ;

Hi, Need to remove space, if found in a String. Ex : if $x=&quot; &quot; then $x=&quot;&quot;; Your help appreciated. Thanks.

Hi, I'm trying to use Unix Mail command. Is there any way I can change the SENDER's name. Is there any option to change the Sender's name ? Thanks in Advance GR

Hi, Help needed abt validation. I need to validate the user-input. I require the user should input as mm/dd/yy. So he should be able to enter in this format only. So until he enters in this format i should not allow him to enter any other values. And I need to check he enters only numbers...

Hi, I'm using Bourne shell and i want to check multiple condition in an if statement using 'OR'. I need to check 2 directories for a particular file. If not found I've to do send mail. if [ ! -f [ /home/dir_1/$filename -o /home/dir_2/$filename ] ] then mail xyz fi It didnt give...

Hi, I'm using a k-shell script and i'm passing command-line arguments as &quot;devel&quot; or &quot;prod&quot; and it gives the error on line number 44 which is the &quot;if&quot; condition. Can you pls let me know what the error is ? myfilename.ksh[44]: devel: bad number if [ $1 -eq...

Hi, I'm having a C-shell script which I'm converting into a Bourne shell script. The problem is there's a 'source' command for which I dont know the equivalent in Bourne shell. Can anyone pls help me out in this ? the following line is the one which I want to change to Bourne Shell...

Hi, I'm displaying content in the browser using JSP. I want to save the content by clicking a button. For this purpose I've this following Javascript command which I invoke onClick of the button which works well in IE but doesnt work in Netscape. Can anyone pls let me know how to achieve it in...