Update duplicate records
Before change: CLAIM_ID CR/RE Internal TAT 11061488 Rebill 27 11061488 Credit 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit After change : CLAIM_ID CR/RE Internal TAT 11061488 Rebill 11061488 Credit 27 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit condition : if Credit – Credit [...]
Answer Question
| November 26, 2012 12:20 PM
SQL Server 2008, SQL Server 2008 64-bit
Before change: CLAIM_ID CR/RE Internal TAT 11061488 Rebill 27 11061488 Credit 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit After change : CLAIM_ID CR/RE Internal TAT 11061488 Rebill 11061488 Credit 27 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit condition : if Credit – Credit [...]
Answer Question
| November 26, 2012 12:20 PM
SQL Server 2008, SQL Server 2008 64-bit
Exchange 2003 (SBS2003) can’t send/receive since we restored Metabase files
Hi everyone, Our Exchange 2003 can no longer send or receive since we restored an old copy of Metabase files, as IIS was not functioning. Since then I’ve deleted & re-created all the associated virtual directories & we can now open IIS & also goto 127.0.0.0/exchange (although) we can’t access it remotely. But the main issue [...]
Answer Question
| November 26, 2012 12:08 PM
Microsoft Exchange 2003, SBS 2003
Hi everyone, Our Exchange 2003 can no longer send or receive since we restored an old copy of Metabase files, as IIS was not functioning. Since then I’ve deleted & re-created all the associated virtual directories & we can now open IIS & also goto 127.0.0.0/exchange (although) we can’t access it remotely. But the main issue [...]
Answer Question
| November 26, 2012 12:08 PM
Microsoft Exchange 2003, SBS 2003
Message queue – Break Handling Program
I should get a break message instead of giving DSPMSG every time, Created message in my lib (TSTMSGQ/TSTLIB) added this in my user prf (TSTPRF). I’m getting completed normally messages whenever a job completes. But every time I should check by giving DSPMSG cmd. Can anyone tell me how to make it into *break mode. [...]
Answer Question
| November 26, 2012 11:20 AM
AS/400, DSPMSG
I should get a break message instead of giving DSPMSG every time, Created message in my lib (TSTMSGQ/TSTLIB) added this in my user prf (TSTPRF). I’m getting completed normally messages whenever a job completes. But every time I should check by giving DSPMSG cmd. Can anyone tell me how to make it into *break mode. [...]
Answer Question
| November 26, 2012 11:20 AM
AS/400, DSPMSG
Mail opened with web browser
Notes opens all internet mail with web browser instead itself (this isn’t valid for internal mail in notes domain)
Answer Question
| November 26, 2012 11:00 AM
Lotus Notes 8.5, Lotus Notes email
Notes opens all internet mail with web browser instead itself (this isn’t valid for internal mail in notes domain)
Answer Question
| November 26, 2012 11:00 AM
Lotus Notes 8.5, Lotus Notes email
RODC problem
While the main DC down, even I make repopulate for passwords, I don’t know what the problem is.
Answer Question
| November 26, 2012 10:25 AM
DC, RODC
While the main DC down, even I make repopulate for passwords, I don’t know what the problem is.
Answer Question
| November 26, 2012 10:25 AM
DC, RODC
Update a file from CL program
Why it is said we cannot update a file through CL? We can use RunsqlStm or Runqry to update a record right? If I select a particular record by using Rcvf or opnqryf and then perform runqry/runsqlstm, will it pick the desired record?
Answer Question
| November 26, 2012 6:45 AM
AS/400, CL Program
Why it is said we cannot update a file through CL? We can use RunsqlStm or Runqry to update a record right? If I select a particular record by using Rcvf or opnqryf and then perform runqry/runsqlstm, will it pick the desired record?
Answer Question
| November 26, 2012 6:45 AM
AS/400, CL Program
IPI prompt type.
What is the purpose of IPI prompt type in RPG? Can anybody explain me with examples?
Answer Question
| November 26, 2012 6:37 AM
RPG
What is the purpose of IPI prompt type in RPG? Can anybody explain me with examples?
Answer Question
| November 26, 2012 6:37 AM
RPG
How to remove timestamp using regular expression
Hi all, I would like to remove TimeStamp to the reports I’m receiving. Basically the report’s format is just the same and I just like to remove the TimeStamp FILE LIBRARY MEMBER FORMAT QASYCPJ QTEMP QASYCPJ4 QASYCPJ4 DATE . . . . . . . 11/20/12 TIME . . . . . . . 13:35:30 [...]
Answer Question
| November 26, 2012 5:35 AM
AS/400, AS/400 TimeStamp
Hi all, I would like to remove TimeStamp to the reports I’m receiving. Basically the report’s format is just the same and I just like to remove the TimeStamp FILE LIBRARY MEMBER FORMAT QASYCPJ QTEMP QASYCPJ4 QASYCPJ4 DATE . . . . . . . 11/20/12 TIME . . . . . . . 13:35:30 [...]
Answer Question
| November 26, 2012 5:35 AM
AS/400, AS/400 TimeStamp
DASD limit
What is the DASD limit (gigabytes) that can be allocated to an LPAR on a i5 570 Power6 that is running V5R4?
Answer Question
| November 25, 2012 9:47 PM
DASD, LPAR Configuration
What is the DASD limit (gigabytes) that can be allocated to an LPAR on a i5 570 Power6 that is running V5R4?
Answer Question
| November 25, 2012 9:47 PM
DASD, LPAR Configuration
Falsification of an email sent from Lotus Notes
Hi I needed from a person an important email with an attachment (I give the person a fictious name here: Name familyname) . The person sent me the email he sent, and the answer he received. Here is what he sent me (I changed the content but respected the format). I told the person that [...]
Answer Question
| November 26, 2012 4:13 PM
Lotus Domino, Lotus Notes 8.5, Security
Hi I needed from a person an important email with an attachment (I give the person a fictious name here: Name familyname) . The person sent me the email he sent, and the answer he received. Here is what he sent me (I changed the content but respected the format). I told the person that [...]
Answer Question
| November 26, 2012 4:13 PM
Lotus Domino, Lotus Notes 8.5, Security
How to give If condition in CL/400 program
Hi, I want to give two If conditions in a cl program to make sure the value of field is between the Range. I am trying to write following line of code but syntax error is coming,any idea/suggestions How can I do comparison at a same time: IF COND(%SST(&ODOBNM 7 4) *LE %SST(&VAR1 7 4)) [...]
Answer Question
| November 26, 2012 12:14 PM
AS/400, CL Program
Hi, I want to give two If conditions in a cl program to make sure the value of field is between the Range. I am trying to write following line of code but syntax error is coming,any idea/suggestions How can I do comparison at a same time: IF COND(%SST(&ODOBNM 7 4) *LE %SST(&VAR1 7 4)) [...]
Answer Question
| November 26, 2012 12:14 PM
AS/400, CL Program
Using Contrlols in ASP.net
What is the difference between using Gridview with and without the GUI
Answer Question
| November 24, 2012 7:19 AM
ASP.NET
What is the difference between using Gridview with and without the GUI
Answer Question
| November 24, 2012 7:19 AM
ASP.NET
Trigger program to validate data and notify interactive program of errors before insert or update action
I have an interactive program that writes (Inventory Management) transactions to a file. I do not have the source for this program. I need to ensure that field content which is not currently validated by the program can be validated and corrected BEFORE the transaction being INSERTed or UPDATEd is written to the file. I [...]
Answer Question
| November 26, 2012 5:52 AM
AS400 RPGLE, RPGLE
I have an interactive program that writes (Inventory Management) transactions to a file. I do not have the source for this program. I need to ensure that field content which is not currently validated by the program can be validated and corrected BEFORE the transaction being INSERTed or UPDATEd is written to the file. I [...]
Answer Question
| November 26, 2012 5:52 AM
AS400 RPGLE, RPGLE
MOMImplementation, Version=2.0.3175.37078,
MOMImplementation, Version=2.0.3175.37078, Whats this and how do I get rid of it. It shows up every time it start computer.
Answer Question
| November 26, 2012 5:33 AM
Microsoft Windows Vista, Windows Vista performance
MOMImplementation, Version=2.0.3175.37078, Whats this and how do I get rid of it. It shows up every time it start computer.
Answer Question
| November 26, 2012 5:33 AM
Microsoft Windows Vista, Windows Vista performance
channel changing
I am having trouble with TIVO …. seems it’s stuck on one channel and does not respond to prompts to change the channel…. I’ve tried the settings but nothing seems to be working….. could it be the IR cable needs to be changed? I’m not tech savvy myself but they said they’d send me new [...]
Answer Question
| November 24, 2012 3:04 AM
channel changing
I am having trouble with TIVO …. seems it’s stuck on one channel and does not respond to prompts to change the channel…. I’ve tried the settings but nothing seems to be working….. could it be the IR cable needs to be changed? I’m not tech savvy myself but they said they’d send me new [...]
Answer Question
| November 24, 2012 3:04 AM
channel changing
UCaaS
What specific criteria should a service provider of a hosted UCaaS enterprise class platform apply to formulate their strategies to increase provisioning capacity?
Answer Question
| November 23, 2012 10:35 PM
Data Center Strategy, UCaaS
What specific criteria should a service provider of a hosted UCaaS enterprise class platform apply to formulate their strategies to increase provisioning capacity?
Answer Question
| November 23, 2012 10:35 PM
Data Center Strategy, UCaaS
What special authority required to access collection services in iSeries Navigator
Kindly let me know what special authority required to access collection services in iSeries Navigator(To pull graphs using iSeries Navigator in Collection services + Graph data)?
Answer Question
| November 23, 2012 3:55 PM
AS/400 administration, iSeries administration, iSeries Navigator
Kindly let me know what special authority required to access collection services in iSeries Navigator(To pull graphs using iSeries Navigator in Collection services + Graph data)?
Answer Question
| November 23, 2012 3:55 PM
AS/400 administration, iSeries administration, iSeries Navigator
IBM Certifications on AS400
Hi, I would like to know the details about IBM Certifications on As400. Please help me by providing this information. If you have any sample questions, please provide that also which will be a great help for me. Thanks in Advance
Answer Question
| November 26, 2012 12:54 PM
AS/400, AS/400 certification
Hi, I would like to know the details about IBM Certifications on As400. Please help me by providing this information. If you have any sample questions, please provide that also which will be a great help for me. Thanks in Advance
Answer Question
| November 26, 2012 12:54 PM
AS/400, AS/400 certification
Information technology
what are the roles of ICT in the management of records and achives?
Answer Question
| November 23, 2012 12:12 PM
ICT advices
what are the roles of ICT in the management of records and achives?
Answer Question
| November 23, 2012 12:12 PM
ICT advices
Debugging in AS400
I have a RPG Program consist of 3000 lines and its using 9 Physical Files and some LF also .. Now i need to debug the program only to find out particular values in particular in Particular PF. In debugging Mode if i press F10 its reading all those records in every PF. How can [...]
Answer Question
| November 23, 2012 8:51 AM
AS/400, AS400 Debug
I have a RPG Program consist of 3000 lines and its using 9 Physical Files and some LF also .. Now i need to debug the program only to find out particular values in particular in Particular PF. In debugging Mode if i press F10 its reading all those records in every PF. How can [...]
Answer Question
| November 23, 2012 8:51 AM
AS/400, AS400 Debug
