1
  • Trim Between Characters

    How do I Trim the text after a spcific character? (ie. www.website.com#http://www.website.com#) Trimed to www.website.com

    MAGco5 pointsBadges:
  • query conversion alpha to numeric

    I have split a field into two new fields by using SUBSTR, but want to define those as numeric fields. How can this be done

    leifsperre5 pointsBadges:
  • STRSQL query

    I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS "RECORD COUNT" FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But I am getting error "Argument 2...

    vibgyor280 pointsBadges:
  • Select substring from clob-field with sql

    How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this...

    DanTheDane2,555 pointsBadges:
  • Seeking Help with SQL SUBSTR Function using Host Variables in COBOL

    Hello All I am currently on version V5R2 and I am trying to make a COBOL program produce some parsed fields from one large field. I have trying to use host variables for al three arguments in the SUBSTR function. The SQL compiler will take a host variable as argument number one but not for argument...

    FCARPENTER200 pointsBadges:
  • UE SUBSTR or RTRIM?

    I need to get cities' name from a format like this: Los Angeles, CA New Orleans, LA etc.. I've tried: substr(a.air_location, -4) but that gives me the opposite...", LA" Any suggestions? Thanks.

    Antgaudi5 pointsBadges:
  • oraoledb non working WHERE clause character comparison

    Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

    Jsl255 pointsBadges:
1

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