Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!
DB2
5K
Solutions
3
Articles & Videos
2K
Contributors
IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.
Refine results
I need to create a store procedure which calls a CL program.
I want the stored procedure to return the output when called.But when i define a stored procedure with input and output parameters im not …
15 views
Hi DB2 gurus,
I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some a…
260 views
- DB2
- Unix OS
- Server Hardware
- Big Data
- Query Syntax
- DB Reporting Tools
I hear db2 can't snapshot... we just have to live with the fact that during backup some oprations (like changes to tables) might hang.... Is this true?
337 views
Experts,
I am able to query a DB2 table from SAS EG using a connection to DB2.
I can assign a library using:
LIBNAME TST DB2 USER=&USR. PASSWORD=&PWD. DATASRC=&SRC.;
The problem is the lib is…
124 views
Historically our IBM i Developers have done their own "Database Administration". We recently got a new manager for our IBM i Development team and they are requesting that our System Administrators t…
637 views
Hi,
I want to check if a Month-Year falls in a date range.
Example: 10-2014 between 01/01/2014 and 12/31/2014
How can i do this in DB2 UDB SQL?
1550 views
Dear Techies,
I have to create a table output based on the following conditions.
Three COLUMNS : TX_Vereinbart, DISCOUNTS, IA_Vereinbart
They all are coming from table called EP101T
The below ar…
453 views
Hi,
Well, this is an Oracle DBA helping an application user that uses DB2.
I am having the below error register in the event viewer of the database server.
Also when i execute the co…
3746 views
Is there a query to run in DB2 (or a command to run that would accomplish the same thing) that will show me all tables with an owner of "username".
I know in Oracle - we would run the following com…
252 views
Using DB2 on an iSeries I need to create a query that will produce sales results for the week, month, and year in one query. I can create them individually and my code for the week is as follows:
…
759 views
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
I am writing a program where the boss wants the calc specs in RPG Free. I am struggling with what used to be a simple thing but its not so simple for me in Free format . The input file has a single …
364 views
I am trying to build a DDL statement off a COBOL program layout. I have never used COBOL syntax before.
I AM NOT SURE WHAT PIC X(26) , PIC XX OR PIC X MEAN?
Example:
Cobol layout
TIMESTAMP …
378 views
In DB2 for i (a.k.a. DB2/400) at V6R1, I want to write a SELECT statement that returns some columns from a header record and some columns from ONLY ONE of the matching detail records. It can be ANY of…
363 views
I have extracted data into Microsoft Access from a DB2-based Finance Application.
Now, I want to be able to see the names of fields in a few tables.
I have the odbc connection set up and my script i…
537 views
I had a DB2 table, mytable, with a field named flr that was defined as char(9). A column was added with a alter table mytable add column flr_num generated always as cast(flr as decimal(5,0). After the…
559 views
Hello all,
I have a need to deploy a DB2 tablespace, diagnostic log files and especially the filesystem monitoring for potential "Log full", and/or "Filesystem Full" situation. I am hoping to "bor…
688 views
I just started a job at a shop that has implemented new standards of programming prior to my hire. We are to write in RPG free format only the C specs curenlty and and use newer solutions in the RPGL…
5116 views
Could any one help me to convert Goergoin Data to Hijri date given in parameter in SSRS. The parameter is integer type where date is converted as =CInt(Format(DateAdd("d",-
6112 views
Is there a way to insert a row into a Microsoft SQL server table from an SQLRPGLE program? Thanks
593 views
The Shellfire Box easily connects all of your devices, even those that don't offer the possibility to establish a safe vpn connection. Access blocked content and surf safely, no matter where in the world you are located.
How to handle Indicatiors for dynmaic subfile (RPG/DDS) :
Atribute Sys1 Sys2 Sys3 Sys4 Sys6 Sys7 Sys8
Diskstatus V…
2195 views
How to mark a field in a subfile record with special color ?
If there is a condition for the subfile-line-field (columne in this line), the filed should be display in special color.
Because Subf…
483 views
Dear Experts,
We have switchover from our Servers (IBM PureFlex) Remote site to Server (IBM PureFlex) Local site. After switchover when I am trying to connect to STRSQL I am getting following messa…
7186 views
Hi all,
I have a situation where a third-party application accessing a DB2 database periodically fills up the log files
which eventually leads to filesystem full problems. Since we don't have any…
685 views
I am seeing a repeated deadlock scenario in an update query and that query seems to be updating the column with the same value . Loooks fishy , is this a reason for the deadlocks ?
UPDATE BAL SET …
555 views
201506-LO-Top-001