Announcement

Collapse
No announcement yet.

Search Result

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

db2 x

  • 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

  • CaptainRon
    started a topic Journals from one system to another

    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

  • Poddys
    started a topic Synchronise DB2 With MySQL Database
    in DB2

    Synchronise DB2 With MySQL Database

    Something that I thought would be fairly easy to accomplish has taken me a week and I just keep hitting roadblocks every step of the way. I am hoping that someone has been able to achieve this and can maybe offer some tips.

    The scenario is that our corporate web site (PHP using the DB2...
    See more | Go to post

  • Gary B
    started a topic SQL Update First Occurrence only?
    in SQL

    SQL Update First Occurrence only?

    Hi Everyone,

    Please forgive me and let me know if this is posted twice, my first post didn't seem to work.

    I have an sql command that seems to be taking a long time to process. My RPG program processes ~ 500k records and runs in less than 1 minute, love my i.

    However...
    See more | Go to post

  • WarrenN
    started a topic Finding records with illegal characters
    in DB2

    Finding records with illegal characters

    Not sure if this should go here or in DDS, but I'm trying to find all records in a table that include illegal characters in any of their fields. There are a little over 1 million records in this table, so hand checking all of them isn't very practical. Does anyone know of a way to detect all illegal...
    See more | Go to post

  • techas400
    started a topic Deletion and updation on different environments(LPARs)

    Deletion and updation on different environments(LPARs)

    Is it possible to compute a file member removal in a rpgle program from a development lpar.

    eg: RMVM FILE(LIB/FILE1) MBR(PAR1981181)
    and performing updation on a different file in a different lpar altogether?

    UPDATE "SCDTA.CORP"/AR#RMTPRL9
    SET...
    See more | Go to post

  • Gary B
    started a topic FTP Question

    FTP Question

    Merry Christmas everyone!

    I have an FTP situation I've not run into before and cannot find anything on this anywhere.

    I need to pick up multiple files from a remote server (not an i).
    I do not know the file names and the names will never be the same name.
    I'd like...
    See more | Go to post

  • jamief
    started a topic Some SQL stuff that everyone already knows
    in SQL

    Some SQL stuff that everyone already knows

    Code:
         H dftactgrp( *no )  OPTION(*NODEBUGIO)                                                         
                                                                                                        
           //---------------------------------------------
    ...
    See more | Go to post

  • abercrombieande
    started a topic Estimating Size
    in DB2

    Estimating Size

    I have a few tables that I would like to estimate the size savings on if I drop a few columns. What is the best way to estimate the savings?
    See more | Go to post

  • BhargavSushant
    started a topic data area command

    data area command

    which command to use for checking that if data area already exist in Library.
    See more | Go to post

Our Sponsors

Collapse
Working...
X