ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
28 results in 0.0008 seconds.
Keywords
Members
Tags
db2 x
  •  

  • tbrantley
    started a topic Using Clob Fields in SQL
    in SQL

    Using Clob Fields in SQL

    Has anyone tried using a clob field inside of SQL?

    I'm moving the data from the YAJL copyBufStr function into a clob variable.

    Once I try to use the clob variable inside the SQL statement I get the error below.

    Length in varying-length, LOB, or XML host variable...
    See more | Go to post

  • How to convert java string to System I alphanumeric

    Hello, Im trying to move a java string to an alphanumeric System I subfile field. The compiler isnt allowing it. How do I convert java string to String to System i alphanumeric. I could noit find anything about it on google.


    rsmd = jdbc_GetMetaData(rs);
    colcnt = jdbc_GetColCount(rsmd);...
    See more | Go to post

  • Alabama Mothman
    started a topic getMetaData Example
    in DB2

    getMetaData Example

    Trying to use RPGILE to obtain a DB2 metadata resultset. Does someone know of a DB2 RPGILE getMetaData example. Do I first have to get a "select" result set before using getMetaData... Trying to get columns and data attributes. Similar to DBU.

    Or can it be built without a beforehand...
    See more | Go to post
  • This topic by lcortesbsr has been deleted by mjhaston

    lcortesbsr
    started a topic DB2 XMLSERIALIZE use in RPG program

  • jemrugIBMi
    started a topic Baby Steps Kerberos

    Baby Steps Kerberos

    Hi All,

    I am researching Kerberos in the IBM midrange environment. I am a developer.

    I have client server desktop application. Front end java(using JT400 api) and backend Rpgle(PCML). So the client is using a mixture JDBC Sql and backend rpgle program calls.

    My...
    See more | Go to post

  • Carpiem
    started a topic Why REGEXP_COUNT returns a wrong value?
    in SQL

    Why REGEXP_COUNT returns a wrong value?

    Hello all,

    I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:

    PHP Code:
    select regexp_count('1','[A-Z]')
    from SYSIBM.SYSDUMMY1 

    Regular expression [A-Z] means it accepts a letter from A to Z. But 1 is no letter, and the result of...
    See more | Go to post

  • rudra
    started a topic Oracle 11i to DB2 on IBM i - Migration
    in DB2

    Oracle 11i to DB2 on IBM i - Migration

    Good Morning/ Evening All,

    Need your expert advice.

    We have a requirement wherein we have to migrate the data from Oracle 11i to DB2 on IBM i (on V7R2). Need your guidance for the below:

    1. Is there any IBM proprietary tool which can help us in the migration? Or...
    See more | Go to post

  • vijayrmca
    started a topic Need to put the same query as DB2 in SQLRPGLE

    Need to put the same query as DB2 in SQLRPGLE

    All,

    I am having one DB2 query

    SELECT year(current date)*10000 +
    month(current date)*100 +
    day(current date-1 days),count(*) FROM mstfile.

    Above query gives me the result as 20200108 ,100 as output...
    See more | Go to post

  • CaptainRon
    started a topic STRPCCMD leaving black 5250 screen

    STRPCCMD leaving black 5250 screen

    All, this works just fine
    STRPCCMD PCCMD(&URL) PAUSE(*NO)

    Except when you call it from the 5250 screen and it opens up a browser the 5250 screen is black and waiting on you to click it before it will display the screen back to where you called the CL from.
    Anyone else...
    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

  • Journals from one system to another

    So I have been doing Journals forever and using them to see what has happened to a file etc. We have a production system that has journaling turned on. What I want to do is extract specific files ( I already know how to do all that ) to the test system. I can do this by extracting the production...
    See more | Go to post

  • CaptainRon
    started a topic Enabling user to end writer and vary off printer

    Enabling user to end writer and vary off printer

    b/c of some weird unknown reason. We have an HP printer that when it runs out of paper it needs varied off and back on. This user does not have authority to the device. How can I in a CL program allow them to do this? I have tried GRTACCAUT but that does not work. Gives me an error saying they...
    See more | Go to post

  • StevenDyke
    started a topic Getting a Token Error When Running on iSeries
    in SQL

    Getting a Token Error When Running on iSeries

    The following sql statement runs from an external IDE but gives me an error on line 15 position 14 When ran in the iSeries environment:
    Error: Position 14 Token SUM was not valid. Valid tokens: ) ,.

    0011.00 UPDATE OIPAYFILES/EMPLOYEE SET PRURN2 = PRURN1 - (PRURN5 + (SELECT
    0012.00...
    See more | Go to post

  • paolinosal
    started a topic Base64 Encode e decode
    in SQL

    Base64 Encode e decode

    HI all,

    I was trying the systools function base64 encode and decode but I have a little problem with the decode...

    here's a test case:

    Code:
    Create Table Testbase64(Rowid Int Not Null Generated Always As Identity (Start With 1, Increment By 1, No
    Cache), Fieldutf8
    ...
    See more | Go to post

  • db2_fetch_assoc() fails mid-way through looping through results

    I have a query which takes less than a second to execute from iNavigator. When I run the same query from a php script and then loop through it using:

    Code:
    $numRows = 0;
    while ($row = db2_fetch_assoc($stmt))
    {
    //Do stuff
    $numRows++;
    }
    echo
    ...
    See more | Go to post

Our Sponsors

Collapse
Working...
X