AS/400 Query – how do you split names in field into seperate fields
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
Which should I do: SAP ABAP or BI?
I am certified in SAP ABAP and I got the job in SAP BI/BW. What should I do? Please help me soon.
Answer Question
| February 22, 2013 3:22 PM
SAP ABAP, SAP BI
I am certified in SAP ABAP and I got the job in SAP BI/BW. What should I do? Please help me soon.
Answer Question
| February 22, 2013 3:22 PM
SAP ABAP, SAP BI
Domino Upgradation 7.0 to 8.5.3
Hi , We are planning to upgrade the Domino server from 7.0 to 8.5.3 Can you tell the right procedure please?
Answer Question
| February 22, 2013 12:41 PM
Lotus Domino 8.5.3, Lotus Domino server
Hi , We are planning to upgrade the Domino server from 7.0 to 8.5.3 Can you tell the right procedure please?
Answer Question
| February 22, 2013 12:41 PM
Lotus Domino 8.5.3, Lotus Domino server
How to display total of all the records that contain the same primary key in RPG4?
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
Data migration from AS/400 DB2 to SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Office 2007 & Windows 8
Will MS Office 2007 ultimate run under Windows 8?
Answer Question
| February 22, 2013 6:01 AM
Microsoft Office 2007, Windows 8
Will MS Office 2007 ultimate run under Windows 8?
Answer Question
| February 22, 2013 6:01 AM
Microsoft Office 2007, Windows 8
How to find the copybook?
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Can you do full system restore twice ie option 21 on go restore menu
Hello, We have a new power 7 machine migrating from a power 6, we are using option 21 to save entire system, then option 21 on the restore menu to restore entire system to the new system. The first restore will be a test. When we go live, the plan is to do the same [...]
Answer Question
| February 22, 2013 2:59 AM
Power 6 machine, Power 7 machine
Hello, We have a new power 7 machine migrating from a power 6, we are using option 21 to save entire system, then option 21 on the restore menu to restore entire system to the new system. The first restore will be a test. When we go live, the plan is to do the same [...]
Answer Question
| February 22, 2013 2:59 AM
Power 6 machine, Power 7 machine
2 iPhones
I have two iPhones 1 personal and 1 work. I want Skype on both. Do I have two download from two different computers? Can I use the same account?
Answer Question
| February 22, 2013 10:48 PM
iPhone, Mobile
I have two iPhones 1 personal and 1 work. I want Skype on both. Do I have two download from two different computers? Can I use the same account?
Answer Question
| February 22, 2013 10:48 PM
iPhone, Mobile
Are you familiar with identity management systems?
As BYOD becomes more prevalent, some companies have turned to identity management systems to safeguard data and employees. Are you aware of identity management systems? Has your company adopted such software tools?
Answer Question
| March 5, 2013 8:08 PM
BYOD, Identity management, Security
As BYOD becomes more prevalent, some companies have turned to identity management systems to safeguard data and employees. Are you aware of identity management systems? Has your company adopted such software tools?
Answer Question
| March 5, 2013 8:08 PM
BYOD, Identity management, Security
Related to move array opration
I have following example in rpg Movea ex1(1940) ex2(1920) here ex1 is an array of length 1940 and ex2 is a data structure of length 1920, if the move array operation performed, Is there any loss of information was there?
Answer Question
| February 21, 2013 3:25 PM
MOVEA, RPG
I have following example in rpg Movea ex1(1940) ex2(1920) here ex1 is an array of length 1940 and ex2 is a data structure of length 1920, if the move array operation performed, Is there any loss of information was there?
Answer Question
| February 21, 2013 3:25 PM
MOVEA, RPG
Virtualisation and CMDB
Our virtualised server environment consists of VMware ESXi hosts on Cisco UCS blades. In order to assess change impact on our services we would like to build CMDB relationships similar to Datacenter -> Floor -> Rack -> UCS FIC -> UCS chassis -> Blade -> Service Profile -> ESXi host -> VM -> Service While [...]
Answer Question
| February 21, 2013 2:26 PM
CMDB, ESXi, VMware
Our virtualised server environment consists of VMware ESXi hosts on Cisco UCS blades. In order to assess change impact on our services we would like to build CMDB relationships similar to Datacenter -> Floor -> Rack -> UCS FIC -> UCS chassis -> Blade -> Service Profile -> ESXi host -> VM -> Service While [...]
Answer Question
| February 21, 2013 2:26 PM
CMDB, ESXi, VMware
TSV file with TRAM & GDS
TSV file raw data should be put in TRAM and GDS applications,there by matching fields should be found and should be put back in Excel file with the reference number from GDS application and unmatched files should be put in excel file with highlighted.. Can anyone could solve this task..
Answer Question
| February 21, 2013 12:50 PM
Microsoft Excel files, TSV file
TSV file raw data should be put in TRAM and GDS applications,there by matching fields should be found and should be put back in Excel file with the reference number from GDS application and unmatched files should be put in excel file with highlighted.. Can anyone could solve this task..
Answer Question
| February 21, 2013 12:50 PM
Microsoft Excel files, TSV file
How do I convert a date in text format to a proper date with AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access [...]
Answer Question
| February 21, 2013 11:22 AM
AS/400, AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access [...]
Answer Question
| February 21, 2013 11:22 AM
AS/400, AS/400 Query
Change the user of a JOB
Hello, I would like to know if it is possible to assign a running job to a different user than the one who ran it? Thanks.
Answer Question
| February 21, 2013 10:13 AM
AS/400, AS/400 commands
Hello, I would like to know if it is possible to assign a running job to a different user than the one who ran it? Thanks.
Answer Question
| February 21, 2013 10:13 AM
AS/400, AS/400 commands
AS/400 Transfer of files
Hi all, Is it possible to transfer the files through DDMF connection. Source system will have single file with single member. While transferring this file to target VPC, it should get added as member? Is that possible in DDMF? I don’t see a member option given in DDMF.
Answer Question
| February 21, 2013 8:05 AM
AS/400, DDMF
Hi all, Is it possible to transfer the files through DDMF connection. Source system will have single file with single member. While transferring this file to target VPC, it should get added as member? Is that possible in DDMF? I don’t see a member option given in DDMF.
Answer Question
| February 21, 2013 8:05 AM
AS/400, DDMF
Source code of WSTest bench mark
Hi, I am doing research in the area of web service and I am looking for a bench mark to test the service. Yesterday I read a document titled “Web Services Performance: Comparing Java 2TM Enterprise Edition (J2EETM platform) and the Microsoft® .NET Framework A Response to Sun Microsystem’s Benchmark Microsoft Corporation July 2004″ . [...]
Answer Question
| February 21, 2013 6:04 AM
Source code, Web Service
Hi, I am doing research in the area of web service and I am looking for a bench mark to test the service. Yesterday I read a document titled “Web Services Performance: Comparing Java 2TM Enterprise Edition (J2EETM platform) and the Microsoft® .NET Framework A Response to Sun Microsystem’s Benchmark Microsoft Corporation July 2004″ . [...]
Answer Question
| February 21, 2013 6:04 AM
Source code, Web Service
Compiling error
*** error in creating required objects for Batch program XXXXX The above messages appeared when I try to recompile a valid Batch Program. This program was error-free. Its purpose is to produce a Payroll Bank report to the spool file. I also have recompiled successfully both the physical files and the logical file this program [...]
Answer Question
| February 21, 2013 1:58 AM
AS/400, Batch program
*** error in creating required objects for Batch program XXXXX The above messages appeared when I try to recompile a valid Batch Program. This program was error-free. Its purpose is to produce a Payroll Bank report to the spool file. I also have recompiled successfully both the physical files and the logical file this program [...]
Answer Question
| February 21, 2013 1:58 AM
AS/400, Batch program
Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Answer Question
| February 21, 2013 11:48 PM
AS/400, CLLE, OVRDBF, RPGLE
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Answer Question
| February 21, 2013 11:48 PM
AS/400, CLLE, OVRDBF, RPGLE
