• SQL command to remove number from within a character string

    What is the SQL command to remove a number from within a character string, when the number repeats later in the string? For example, '10PtreeGB-m1 01-01'. I want to remove the 1 after the m, but leave the rest of the characters unchanged (before and after)?

    mskent5 pointsBadges:
  • One doubt on SQL command “Like”.

     Hi One doubt on SQL command \"Like\". File 1 File Name:- A1 Filed(A1F):- 10 0  Zoned File 2 File Name:- A2 Filed(A2F):-  30 Character Please help me to search the data from file 1(A1) field data(A1F) value is present or not on file 2(A2) filed (A2F). I need to search multiple data from the pf...

    amalrajvs20 pointsBadges:
  • Save SQL commands in a CL?

    How can I save SQL Commands in a CL?

    Pt0505145 pointsBadges:
  • How to write multiple SQLRPGLE records into a printer file

    C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File. Here actually I am getting 3 records as output. But I don't know how to write those 3 records into a printer file. Can anybody explain me how to write the...

    Sasikumarr195 pointsBadges:
  • inserting many columns

    i want to insert new columns like day1, day2, day3, etc. in a database by passing a veriable in day(n), please help me what i can do for this

    noor6125 pointsBadges:
  • Is it possible to give a user access to sql screen wherein he is allowed only to use select commands

    Is it possible to give a user access to sql screen wherein he is allowed only to use select commands. We have a team of users who use a set of 10 - 15 select commands on daily basis.

    JohnsonMumbai1,160 pointsBadges:
  • How to search more than a word in a column SQL database?

    i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute("SELECT idf FROM instance WHERE instance='"+ word +"'")     conn.CommitTrans() but some of the searchword cannot be...

    Semantic855 pointsBadges:
  • SQL WKS SELECT COMMAND

    Thanks for your response. Actually i am using Oracle 7.3.1 with Devloper 2000 I want to get information from a table name ‘bilmst’ having column name ‘a/c no.’ and ‘enterdate’ i want to collect information as follows fy 01-07     No of A/Cs to 30-06 2005-06        1500...

    23523523595 pointsBadges:
  • I want to delete records from a PF outside a PGM

    I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I'm not sure how to pass variable to either idea.

    TIB5 pointsBadges:
  • SQL command question

    I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don't know...

    Ktoby55 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • SQL Server 2008 Code to find fields containing similar text

    I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word "Smith" Field 2 has "Smith AB" in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • SQL Server table structure

    Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

    Tablestructure15 pointsBadges:
  • I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS

    VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE

    UUKKY15 pointsBadges:
  • Retreiving AS/400 SQL scripts

    When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

    Morticia00110 pointsBadges:
  • 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,160 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following