Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Stored Procedure Problem

Stored Procedure Problem

Stored Procedure Problem

Hi All Experts
I need solution for 2 problems

1) I have to figure out the latest record from the table, i.e. If a service number is having multiple records with same category and code, but in different dates. I need to access latest record. (If the records are in JAN/FEB/MAR, then I need March record. I tried it with MAX, but not getting latest record) . Please help me

2) I need to write a stored procedure which Inserts/Updates multiple tables, in multiple conditions i.e.  (Based on clients business unit,customer,service,bill,billhistory etc).Help is appreciated

RE: Stored Procedure Problem

First, I hope you realize this is the Informix 4GL forum.  If your proposed stored proc isn't called by 4GL, you probably are better off in the Informix Dynamic Server forum.

As far as your first requirement is concerned, MAX what?  date?  If it is a date date type, then, no, you may not get the right record if more than one record exists for a given date.  You probably want to use a datetime data type.

For your second question, your requirements are way too general.  Your best bet is to post your work and tell what your specific problem is.

RE: Stored Procedure Problem

Hi olded,
here is my problems in breif
I think I am into correct forum,

1) SELECT  a.service_type,

     INTO   v_service_type,
        reqbtbb a,
        reqradius c

     WHERE a.provision_type = 'MGK'
     AND a.req_status = 'C'
     AND a.mac_expiry_date <= TODAY
     AND c.action_type = 'XT'
     AND c.client_no = a.client_no
     AND c.service_no = a.service_no
     AND a.create_dtim = (SELECT MAX(create_dtim) FROM reqbtbb d  WHERE d.service_no = a.service_no AND d.client_no = a.client_no )

this query is not returning latest record

2) For second question
Select a.business_type,c.brun_no
From client a, clntbill b,billhist c, clntpopt d, clntrchg e

where a.client_no = b.client_no
and a.client_no = c.client_no
and a.client_no = d.client_no
and a.client_no = e.client_no

and a.business_unit='RESI'
and a.code_12='PO'
and a.business_type='P'
and b.email=''
and d.pay_option='CH'
and a.datetime_modified = e.datetime_modified

based on the above condition, I need to update CLNTRCHG table, with new value,.. for this I have been told to write stored procedure which contains TEMPARARY tables in Informix,with the help of temp tables, I need to updated the data /...............
 I am not that good at stored procedures...,,,

Please help me

Thanks in advance


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close