• Need to know the date and time a particular sql command was fired through an interactive session

    Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

    JohnsonMumbai1,390 pointsBadges:
  • Count/Sum Question

    Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

    Chhmusic15 pointsBadges:
  • SQL select command

    Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...

    Abrahm7570 pointsBadges:
  • Need help with SQL commands

    hye there i need some guidance on sql command. i accidently update all data in 1 table to be as one data only. may i know how i want to revert back to the previous data. or at least what is the sql command to use to make the data in that table updated according to their own data by referring to...

    Calezz5 pointsBadges:
  • Create Alias In Rexx

    I am trying to execute the sql create alias in a rexx source however it fails with sql error 901, have tried command manually & works fine

    Markpg155 pointsBadges:
  • SQL Commands

    Hi friends, How can I see or get the SQL commands executed from another user ? Regards, Roberto

    SILVARB440 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following