Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
How do I access F15 on my keyboard when it only goes to F12?
Hi, Can anybody tell me about OVRDBF in real time answers?
How do you know a record exists without doing read and chain?
Fstdt if e disk Dnam s 10a Ddept s 3a C/exec sql C+ SELECT NAME, BRANCH INTO :nam, :dept FROM stdt WHERE STDID < 10 C+ C/end-exec C seton lr Hai all ..! I have this code .. But i'm not getting the output.. how can i get the result?
How to sort array in Descending order using SORTA Command?
I have 5 Different Files with 5 Members. I wanted to process all records in all members. I used OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL command. It did not convert all records in all members. My AS400 version is not supporting EXTMBR(*ALL).
I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?
Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double click on any field, the field automatically appears in the sort by window...
Hello I created metadata over a "set" of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error...
I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...
I have to run a Query based on PF without DDS with record length 2997. I have to select Company Code '01' which is the 925-927 positions in the file. How do I do select in the Query? Please advice. Thank you.
How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....
The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...
How to search particular text_item in a field having lot of data? How to put find button option in a form and how to write in that coding.
I'm editing a document in another language, and want to change the spell check language of this document. I usually use MS Word 2010 when writing documents. Will making a change to this particular document affect other English-language documents (meaning does not save by default) I write?
Hi sir, I am a beginner for developing forms and reports, in my office they are using oracle forms 6i. Can you please tell me how to develop a basic form?
I want to know the coding for button which is named as 'next'...i want to fetch next records every time i press this button in my form... but my coding is not woking properly...i dont get any error...but i dont even get any output too...as the fields in output screen(form) remains empty...but yes...
I am using command OVRDBF to override my database physical file suppose "ABC " (file to be overridden) and second physical file let "DEF" (the one with which we are overriding) now I execute this command: OVRDBF FILE(ABC) TOFILE(LIBRARY/DEF). After the execution of this command when I use the...
DCLF FILE(EMP001P) RCvF RcdFmt(EMPREC) OVRDBF FILE(EMP001P) TOFILE(EMP001P) MBR(SECOND) + SHARE(*YES) MONMSG MSGID(CPF0000) EXEC(SNDUSRMSG MSG("ERROR") ) RCvF RcdFmt(EMPREC) Here, I'm unable to overwrite the EMP001P file with second record. pls suggest correct way to do it.
In a single CL/400 program, is it possible to declare physical file File1, then read a record and later writing the record value onto the DSPF using OVRDBF with in a same CLP?