Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, 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
Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...
I'm hoping someone can help me! In my RPGLE program, I currently can't see the DSPLY 'some text' output in the command window. I'm using IBM WebSphere development studio client for iSeries to create a simple RPGLE program. I'm compiling the program with no errors or programs but I can't see the...
How do we post the entries in 2006, when we were in the current year 2007 in SAP Fico module?
Our network people want to make the printers in the network all DHCP devices.How do I get the iseries to recognize the printers without creating a host table entry?The DNS servers are listed in CHGTCPDMN but if I ping the device name I don't get a response.
I'm designing a remote Java program to look up zip codes for RPG running on iSeries V5. Its a web client service running in Websphere. Is there a way I can set this up so that the calls go through RPG instead of having to create another Java program to handle it?
My background is certainly in MSSQL and I've asked people at my company if they have created indexes on certain columns. They always says yes but point me to logical files.When I'm using iSeries Navigator, logical files show up under the "Views" category. However, when I click "Indexes", nothing...
this is the message: ERR (IN-USE) by another sessoin or for maintenance, ever since I added same emails to galaxy note 3.
Sometimes I get a question mark, other times I get a little square box, instead of the image it is supposed to display. Most of my friends are PC users so I don't know what the file format is. I use Safari on an IMAC with OS 10.9............any suggestions ?
I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?
I've recently been looking at some legacy programs, such as the following code:C/free Dow 1=1; SubRoutine(); EndDo; *INLR = *On; /end-freeThe program that I'm questioning is a "server-like" program, where the sub routine handles incoming requests over the network. I feel like the *INLR=*On...
Is it possible to install GIT on an AS/400 system running PHP?
Access Database Question. I have two databases: Company and project. I want to be able to input a primary and secondary description of the work at the project level that is saved at the project level, but also adds to the company database (if that primary and/or secondary description hasn't already...
I want to be able to display a window with a 24x80 screen size, without removing the background SFL which is displayed with a 27x132 screen size. Haven't been able to do it. I have tried 2 different formats in one display file, using 2 line and position definitions per field (one for DS3 and...
I have about 4 years experience in inside sales - storage, middleware,cloud and SAP mobility. I want to prepare for senior Techno Commercial roles. Can you suggest few certifications that I should acquire.
Any information or resources on Microsoft's 2010 Excel PowerPivot. Thanks!
My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...
Within Java, how can I call a RPG Function that can pass parameters, return result sets, and output parameters?
We're currently using an AS/400 system. I was asked by my boss to to look for a way to call RPG programs from PHP on our Apache server. The only solution I've come up with was installing Zend server to AS/400 and using the i5 PHP API Toolkit. Since I don't fully understand AS/400, I haven't tried...
I have a masters life sciences and have a non-IT background. I am working for the past 3 years as a research scientist in the field of pharmaceutical R&D for a start up company. Will SAP help me to increase my value in the pharmaceutical industry? What kind of training should I go for?...
Hi, I have recently downloaded the Mochasoft trial version. I installed the same in my personal laptop for my basic learning. Now the problem I'm having is I'm not able to connect to the AS/400 server. Can anyone please share the IP address which can be connected to AS/400 for public usage? Or tell...