CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
How to access Exchange Server live
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
Communication Engineer career and certification options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
Software
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
Microsoft Excel
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Table setup
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
Find and Replace
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
Tax entity
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
How to convert QF file to Word document?
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
Lotus Code Needed
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
Link for Windows Server 2008 interview questions
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Parameter Manipulation – Turning ‘abc’ type string into a number
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
VFP sub-menu pops to left in Windows 7
I have a VFP 9 application running on Windows 7. The problem is that all sub-menus appear to left of the parent menu? If I run the application on XP, the menus work correctly. I applied SP2 (10/16/2007) and it did not resolve this issue. Any suggests would be appreciated.
Answer Question
| November 16, 2012 3:14 PM
Menu, VFP9, Windows 7
I have a VFP 9 application running on Windows 7. The problem is that all sub-menus appear to left of the parent menu? If I run the application on XP, the menus work correctly. I applied SP2 (10/16/2007) and it did not resolve this issue. Any suggests would be appreciated.
Answer Question
| November 16, 2012 3:14 PM
Menu, VFP9, Windows 7
Debug
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
Calculate Duration for Annual Leave
Hi, I have Lotus Notes application which is for Leave applying. I have calculate duration function to calculate duration of leave when user put Date from to Date to. This function did not calculate Saturday and Sunday as working day even the user put Saturday and Sunday in their leave. But the problem is some [...]
Answer Question
| November 16, 2012 12:40 PM
Lotus Notes, Lotus Notes Application
Hi, I have Lotus Notes application which is for Leave applying. I have calculate duration function to calculate duration of leave when user put Date from to Date to. This function did not calculate Saturday and Sunday as working day even the user put Saturday and Sunday in their leave. But the problem is some [...]
Answer Question
| November 16, 2012 12:40 PM
Lotus Notes, Lotus Notes Application
Transaction codes for SAP BI reports testing
Transaction codes for SAP BI reports testing
Answer Question
| November 16, 2012 8:19 AM
SAP, SAP BI
Transaction codes for SAP BI reports testing
Answer Question
| November 16, 2012 8:19 AM
SAP, SAP BI
AS/400 MENU contain message
I am new in as/400 . I want to know how can I create menu and when I run the menu show me message like : ————————————————————————– Enter the queue name : _____ ————————————————————————– ————————————————————————– ————————————————————————– Enter the Printer name: _____ ————————————————————————– ————————————————————————– ————————————————————————–
Answer Question
| November 16, 2012 6:41 AM
AS/400, as/400 menu
I am new in as/400 . I want to know how can I create menu and when I run the menu show me message like : ————————————————————————– Enter the queue name : _____ ————————————————————————– ————————————————————————– ————————————————————————– Enter the Printer name: _____ ————————————————————————– ————————————————————————– ————————————————————————–
Answer Question
| November 16, 2012 6:41 AM
AS/400, as/400 menu
Unable to see freenas from file browser on windows network?
I have setup a FreeNas server and I can connect to it using a Windows XP machine. When I try to connect to the freenas server from Fedora 12 I get the following message “unable to mount location – failed to retrieve share list from server”. I have verified SAMABA is running and I can [...]
Answer Question
| November 16, 2012 3:27 AM
Samba, Windows XP
I have setup a FreeNas server and I can connect to it using a Windows XP machine. When I try to connect to the freenas server from Fedora 12 I get the following message “unable to mount location – failed to retrieve share list from server”. I have verified SAMABA is running and I can [...]
Answer Question
| November 16, 2012 3:27 AM
Samba, Windows XP
Exchange Server 2003 SMTP Issues
We recently switched ISPs and in doing so got assigned a different static IP address. That’s when the problems began. Some emails go through without a hitch. Gmail for example delivers normally. There are others, however, that get hung up in the queue displaying errors like: “The connection was dropped by the remote host.” “The [...]
Answer Question
| November 16, 2012 8:55 PM
Exchange Server 2003, Microsoft Exchange Server
We recently switched ISPs and in doing so got assigned a different static IP address. That’s when the problems began. Some emails go through without a hitch. Gmail for example delivers normally. There are others, however, that get hung up in the queue displaying errors like: “The connection was dropped by the remote host.” “The [...]
Answer Question
| November 16, 2012 8:55 PM
Exchange Server 2003, Microsoft Exchange Server
Lotus Notes 8.53FP1 – Dock the Open List – Internet Explorer Links with no favorites
We have the dock open along the side and the item labeled Internet Explorer links has one link in there. And that’s it, even though my IE8 has many favorites. I have shut down Notes, and IE8, and even the PC itself. Log back into Lotus Notes and have the same issue. I tried updating [...]
Answer Question
| November 17, 2012 7:59 PM
Internet Explorer 8, Internet explorer links, Lotus Notes 8.5.3
We have the dock open along the side and the item labeled Internet Explorer links has one link in there. And that’s it, even though my IE8 has many favorites. I have shut down Notes, and IE8, and even the PC itself. Log back into Lotus Notes and have the same issue. I tried updating [...]
Answer Question
| November 17, 2012 7:59 PM
Internet Explorer 8, Internet explorer links, Lotus Notes 8.5.3
