Announcement

Collapse
No announcement yet.

Search Result

Collapse
64 results in 0.0075 seconds.
Keywords
Members
Tags
  • You can also choose from the popular tags.

sql x

  • eloiselle
    started a topic Tracking Usage of a View
    in SQL

    Tracking Usage of a View

    Hello everyone,

    I've been trying recently to create some sort of event monitor (not sure if this is a correct solution) in DB2 to try to keep tracks of a view's usage (each time it i used it in a SELECT statement, for instance).
    I've seen multiple solutions existing for T-SQL, but...
    See more | Go to post
    Last edited by eloiselle; March 11th, 2019, 12:05 PM. Reason: Added tags

  • DougCMH
    started a topic CREATE FUNCTION (External) - Which Subprocedure?
    in SQL

    CREATE FUNCTION (External) - Which Subprocedure?

    Something I'm not clear on - In reviewing the syntax for CREATE FUNCTION (External), I know I can specify that the external procedure to be run is a subprocedure in a service program, and where to specify the service program.

    However, I don't see where to specify the name of the actual...
    See more | Go to post

  • DougCMH
    started a topic Getting information on an SQL SEQUENCE object
    in SQL

    Getting information on an SQL SEQUENCE object

    How can I get the current value of an SQL SEQUENCE object, WITHOUT incrementing it with NEXT VALUE FOR first?

    Also, how can I get information about a SEQUENCE, such as min, max, increment value, etc?
    See more | Go to post

  • inigo.redin
    started a topic How to reclaim unused space from LOB/CLOB columns?
    in SQL

    How to reclaim unused space from LOB/CLOB columns?

    Hi.

    I've been testing how the CLOB columns work (relative to disk space ).

    I've tried erasing data from a couple of columns with CLOB data type (it seems VARCHAR and the other LOBs work in the same way).
    I see there is no change about the size on disk occupied by the...
    See more | Go to post

  • jason.aleski
    started a topic Looking for Query/400 Alternative?

    Looking for Query/400 Alternative?

    I'm currently in a very "traditional" and small IBM i/IT shop (6 person crew). While its been bitter-sweet to have some of our IT staff for 30+ years, they will soon be leaving the workforce for retirement, etc; thus my responsibilities will be more focused on the IBM i. We still rely heavily...
    See more | Go to post

  • CaptainRon
    started a topic DataStructure SORT on two different fields.....

    DataStructure SORT on two different fields.....

    So I have a Data structure array. I can sort on one field using the SORTA command with %subarr. Can I add another field WITHOUT combining the two fields together in a one field sort? To basically sorting on two fields or three etc..... Again without combining into one field. If I can in SQL do you...
    See more | Go to post

  • VigneshMohan
    started a topic Override System Default Value - Date Column
    in DB2

    Override System Default Value - Date Column

    The system defined default value for a date column in DB2/iSeries is always "current date". How can we change that to '01/01/0001' (*LOVAL) ?

    When I insert a record via RPGLE, the date fields always default to *LOVAL.
    Whereas, when I insert a record using SQL (or an ETL
    ...
    See more | Go to post

  • Gary B
    started a topic Dspfd *accpth
    in DDS

    Dspfd *accpth

    Hi all,

    I wasn't sure where to post this so here goes. If it belongs somewhere else please let me know.

    I'm going crazy over a problem I cannot resolve, I've wrestled this for days and all my research hasn't turned up anything.

    I am getting a "decimal data...
    See more | Go to post

  • gunnypatel
    started a topic XMLATTRIBUTE Function New Line Character
    in SQL

    XMLATTRIBUTE Function New Line Character

    I am trying to create an XML using the SQL XML functions. One of the things that I need to do is add newlines to an attribute value. The special character sequence for new line is " ". When I run that through the XMLATTRIBUTE function it comes out as 
 because the &...
    See more | Go to post

  • Stored procedure on AS400 - how works cursor and update statement

    Hi guys, I have a question, I have a stored procedure on AS400 and I see that I can call like this: call library.prcocedure_name(parameters), the object on AS400 is *pgm type. I never worked since now with stored procedure and for this reason I don't have very large knowledge.
    I understand that...
    See more | Go to post

  • SET based SQL Tip - Splitting rows using common table expressions

    This document contains two real world examples which show how to use SET based SQL and common table expressions, to split input rows, into multiple output rows, unconditionally, or conditionally.

    There are many reasons to shift many types of work to SET based SQL, but improved performance...
    See more | Go to post

  • Vectorspace
    started a topic Dynamic SQL - conditional build vs embedded conditions
    in SQL

    Dynamic SQL - conditional build vs embedded conditions

    I'm working on an SQL program that will read data from a file into a subfile. There are lots of optional conditions that the user can input.

    I'm looking at two approaches.

    The obvious way is dynamically including only the relevant conditions when I build the SQL string,...
    See more | Go to post

  • Keith Hodges
    started a topic Dropping a schema without generating inquiry message CPA7025
    in SQL

    Dropping a schema without generating inquiry message CPA7025

    I'm writing either a CLLE program or an SQL script to build a schema full of tables, programs, and service programs, and I'd like it to be fully automated.

    My issue is that in the beginning of the CL, when dropping the schema if it already exists, an inquiry message, CPA7025, is generated...
    See more | Go to post

  • Free e-book: Converting RPG to Set Based SQL (Part 1: Input Operations)

    Below is a link to download a free e-book to help current, or former, RPG programmers learn SET based SQL. There are significant benefits when using SQL for I/O, but the benefits increase dramatically when you use SET based SQL (versus one row at a time processing). This is a learn by example book with...
    See more | Go to post

  • JoeOlliff400
    started a topic Slightly Complicated Statement works one place not another

    Slightly Complicated Statement works one place not another

    So, I have the following SQL statement.
    PHP Code:
     EXEC SQL
         INSERT INTO ENTPART 
    (IRS#,ITEM#,OKAYTOUSE,HTS#1,HTS#2,HTS#3,
         
    DESC,UNT$,WGTLN,PCLS,PRDCD,COMM1,COMM2,COMM3,COMM4,COMM5,
         
    COMM6SELECT DISTINCT (SELECT IRS#CS FROM CUSTHEAD
         
    where CUS#CS = $S_CUSTF 
    ...
    See more | Go to post

Our Sponsors

Collapse
Working...
X