Search:

Type: Posts; User: grofaty; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Thanks, exactly what I need.

    Thanks, exactly what I need.
  2. How to indentifiy if database is using UTF-8 code page or not with select statement?

    Hi,
    I know I can use db cfg parameter:


    db2 get db cfg for baza | grep "Database code"
    Database code page = 1208
    Database code set ...
  3. @mark.bb, OK fine. Thank you. Just one more...

    @mark.bb, OK fine. Thank you.

    Just one more think. About my second question from my first post.

    For example having two databases:


    db2 CREATE DATABASE data2 USING CODESET UTF-8 TERRITORY SI...
  4. @mark.bb, this works great. Thanks a lot. ...

    @mark.bb, this works great. Thanks a lot.

    Above solution is super, but just wondering is there maybe some setting at db2 client or similar that this setting becomes default and I don't need to...
  5. How to create UTF-8 database with proper sorrting of non-English characters?

    Hi,
    I have DB2 Advanced Workgroup Server Edition 11.1 fixpack 2 on Linux/Intel. I am interested in using BLU technology. I need to create a database to support Slovenian characters which are beside...
  6. Hi, actually correct code is: ... FOR...

    Hi,
    actually correct code is:


    ...
    FOR
    ROW AS
    c1 cursor with hold for
    SELECT
    ...
  7. Stored procedure error: SQL0501N The cursor specified in a FETCH statement or CLOSE

    Hi,
    on DB2 v11.1 fixpack 2 on Linux I would like to write a stored procedure to validate all of the not valid stored procedures.
    Bellow is simple sample how to reproduce a problem.

    Regards


    ...
  8. @mark.bb, tested and working fine. Thanks a lot...

    @mark.bb, tested and working fine.
    Thanks a lot for this solution!
  9. @db2mor, I was already thinking about scripting...

    @db2mor, I was already thinking about scripting language, but I was just wondering if there exists some native db2 solution in order I don't invent something already available.
  10. How to reset genereated column with one single command?

    Hi,
    my system DB2 11.1 fixpack 2. To simplify my problem I have a table:


    CREATE TABLE ADMIN.TABLE1 (
    COL1 INT NOT NULL,
    COL2 CHAR(10)
    );
    with two rows:
  11. SQL question: How to display only third word from character field for each of the rec

    Hi,
    using DB2 v11 fixpack 2 on Linux.

    PROBLEM: From character field I would like to get ONLY THIRD WORD from each of the record.

    From sample table:


    COL1
    ------------------------
  12. Stored procedure: How to create continue handler for OK message?

    Hi,
    in DB2 v11 fp2 on Linux I have a requirement to write a stored procedure to log SQL actions into admin.log table.

    Simplified sample:


    CREATE TABLE ADMIN.TAB1 (COL TIMESTAMP);
    CREATE...
  13. What are system packages SQLABG02, SQLC2G13, SQLC2J23 and SQLC2K26 with schema NULLID

    Hi,
    I have to migrate tables, view, etc from old DB2 v8.2 on Intel/Windows database to DB2 v11.1 on Intel/Linux database.

    Now I am looking into authorizations and I see some users have had access...
  14. I just didn't know that. The whole day I have...

    I just didn't know that. The whole day I have spent yesterday debugging this problem, this single 'server fixpack' info I have learned from you was worth it.

    Now I have downloaded "license" file...
  15. @db2mor, thanks a lot for your help, I manage to...

    @db2mor, thanks a lot for your help, I manage to solve the problem.

    I did the following:
    1. created a virtual machine snapshot (so I can revert back to this state).
    2. I installed "rpm" package...
  16. db2setup exists with error before install window opens

    Hi,
    I have installed "Ubuntu 16.04 x86_64 minimal" and now I would like to install DB2 11.1 Advanced Workgroup Server Edition.

    I have logged into Ubuntu using ssh and if I execute:

    ./db2setup...
  17. @mark.bb, now I see the problem is actually in...

    @mark.bb, now I see the problem is actually in REPLACE function, I thought it is in CHR executing using special characters, but obviously not. So the following select has the same problem:

    SELECT...
  18. @mark.bb, I have been testing your idea whole...

    @mark.bb, I have been testing your idea whole day. Changing CODEUNTIS32 database parameter like:
    db2 update db cfg for <database> using STRING_UNITS CODEUNITS32
    solves the problem.

    The side...
  19. How to transfer tables between different operating systems and code pages?

    Hi,
    in our company we have DB2 v8.2 on Windows 2003 with database code set 1250 with 500 tables (source database).
    I should move this tables to DB2 v11 on Linux/Intel with code set UTF-8 (target...
  20. @DNance, in many cases it is law restrictions. In...

    @DNance, in many cases it is law restrictions. In a lot of cases I am not allowed to have gaps in numbering, because it is difficult to prove something has not been deleted because of gaps.

    As it...
  21. How to prevent gaps in "generated always as identy" columns if error is returned?

    Hi,
    using DB2 v10.1 fixpack 1 on Linux/Intel.

    I created table:

    CREATE TABLE ADMIN.TAB (
    ID INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),
    UNIQ INT...
  22. Actually the above sample with temporally table...

    Actually the above sample with temporally table is just simplified sample, what I need is selecting data from table where I am sure there is new line character stored in table. Lets look at the...
  23. I have investigated this problem in detail. It...

    I have investigated this problem in detail. It looks like db2 CLP eats new line character. If we carefully look at the results in all of above posts (e.g. #9) it is clear text is displayed in one...
  24. mark.bb, it doesn't work correctly. select...

    mark.bb, it doesn't work correctly.



    select s,
    xmlcast(
    xmlquery('fn:replace($s, $p, $r, "s")' passing
    t.s||chr(10) as "s"
    , '--.*?\n' as "p"
    , '' as "r"
  25. @mark.bb, I did several tests and I see both "s"...

    @mark.bb, I did several tests and I see both "s" flag and "\W" switch are required. Thanks.

    During testing a new problem pop-ed up. If there is a comment in text I would like to ignore comment...
Results 1 to 25 of 41
Page 1 of 2 1 2