FTP to Get File from UNIX to AS/400
I should retrieve a file from UNIX to AS/400 (V5R3) to a data base file using FTP. But the File name on UNIX is RCVWFB01(SNDCHS01)20120203_092924.cnt. Now If I try to use GET command on AS/400, as GET RCVWFB01(SNDCHS01)20120203_092924.cnt LIBRARY/FILE.MEMBER, It throws me an error saying Invalid arguments.
Answer Question
| March 19, 2012 12:32 AM
AS/400, iSeries networking, iSeries V5r3M0
I should retrieve a file from UNIX to AS/400 (V5R3) to a data base file using FTP. But the File name on UNIX is RCVWFB01(SNDCHS01)20120203_092924.cnt. Now If I try to use GET command on AS/400, as GET RCVWFB01(SNDCHS01)20120203_092924.cnt LIBRARY/FILE.MEMBER, It throws me an error saying Invalid arguments.
Answer Question
| March 19, 2012 12:32 AM
AS/400, iSeries networking, iSeries V5r3M0
BI extractors
When getting information from the HCM module where does BI get the data to populate the cubes?
Answer Question
| February 27, 2012 10:21 PM
SAP HCM, SAP Reports
When getting information from the HCM module where does BI get the data to populate the cubes?
Answer Question
| February 27, 2012 10:21 PM
SAP HCM, SAP Reports
Identifying Series of numbers in a string
Hi, I seek your help in designing a RPG /RPGLE program which will identify the series of numbers among the character string (like phone #s, Credit card number, etc..) Ex: If String A = ‘ABCDSSS123456DDB7BB’ My result field should only fetch ’123456′ and not ’7′. (in this example ’7′ is not among series). Can someone [...]
Answer Question
| March 17, 2012 10:06 PM
AS400 RPGLE, AS400/RPG, RPGLE
Hi, I seek your help in designing a RPG /RPGLE program which will identify the series of numbers among the character string (like phone #s, Credit card number, etc..) Ex: If String A = ‘ABCDSSS123456DDB7BB’ My result field should only fetch ’123456′ and not ’7′. (in this example ’7′ is not among series). Can someone [...]
Answer Question
| March 17, 2012 10:06 PM
AS400 RPGLE, AS400/RPG, RPGLE
login form for Oracle
hi, i want to create a login form that validates the username and password from the database. the username and passwors are stoed in the database. table:login column: empid, password
Answer Question
| February 27, 2012 3:46 PM
Oracle, Oracle Database, Oracle Forms
hi, i want to create a login form that validates the username and password from the database. the username and passwors are stoed in the database. table:login column: empid, password
Answer Question
| February 27, 2012 3:46 PM
Oracle, Oracle Database, Oracle Forms
Link RDP in Microsoft Access to click computer name to remote control
I have build a Microsoft Access 2007 database for trouble tickets and inventory. I have a table called INVENTORY. One fo the fields is DEVICE NAME. Right now it is simpy a text field. In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE NAME field. I would like [...]
Answer Question
| February 27, 2012 2:48 PM
Microsoft Access 2007, Microsoft Access fields
I have build a Microsoft Access 2007 database for trouble tickets and inventory. I have a table called INVENTORY. One fo the fields is DEVICE NAME. Right now it is simpy a text field. In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE NAME field. I would like [...]
Answer Question
| February 27, 2012 2:48 PM
Microsoft Access 2007, Microsoft Access fields
Windows list of modified file associations (only)
Is there any way/program to list all the modified file associations (that is, changed from their default) on a Windows 7 system? This would help in replicating a user’s environment on another system.
Answer Question
| March 17, 2012 2:26 PM
File associations, Windows 7
Is there any way/program to list all the modified file associations (that is, changed from their default) on a Windows 7 system? This would help in replicating a user’s environment on another system.
Answer Question
| March 17, 2012 2:26 PM
File associations, Windows 7
AS/400 Source. Physical Files. Key Fields?
We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?
Answer Question
| March 17, 2012 10:29 AM
AS/400, AS/400 Fields, as/400 files
We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?
Answer Question
| March 17, 2012 10:29 AM
AS/400, AS/400 Fields, as/400 files
Connecting visual basic with SQL server
i want to connect visual basic with mysql server
Answer Question
| February 27, 2012 10:14 AM
SQL Server, Visual Basic 2008
i want to connect visual basic with mysql server
Answer Question
| February 27, 2012 10:14 AM
SQL Server, Visual Basic 2008
Network Security – VLANs and APs – Additional Securiy risks?
Well, I’ve been kicking this around and thought I’d ask some experts out there. I’m planning on implementing some Wireless Access Points for guestemployee access. The APs will be connected to the core network on VLAN’d ports. I’m wondering about the security issues involved with this beyond the following assumptions; Native VLAN active on core [...]
Answer Question
| February 27, 2012 4:28 AM
Cisco Access Points, Cisco Routers and Cisco Switches, Cisco VLAN
Well, I’ve been kicking this around and thought I’d ask some experts out there. I’m planning on implementing some Wireless Access Points for guestemployee access. The APs will be connected to the core network on VLAN’d ports. I’m wondering about the security issues involved with this beyond the following assumptions; Native VLAN active on core [...]
Answer Question
| February 27, 2012 4:28 AM
Cisco Access Points, Cisco Routers and Cisco Switches, Cisco VLAN
IBM I-series Data Download
I run a query in query/400 and tried to download that file using IBM Iseries. in the downloaded file, the column headers are in field ids and not the descriptions i have given in Query/400 report column formatting. Is there any way to download a file with column descriptions given in query? Please suggest.
Answer Question
| March 17, 2012 4:25 AM
AS/400 Query, AS400 iseries, Query/400
I run a query in query/400 and tried to download that file using IBM Iseries. in the downloaded file, the column headers are in field ids and not the descriptions i have given in Query/400 report column formatting. Is there any way to download a file with column descriptions given in query? Please suggest.
Answer Question
| March 17, 2012 4:25 AM
AS/400 Query, AS400 iseries, Query/400
need to change password of router
my wouter has 6 character password. my iphone doesn’t take less than 8 character. I need to change the password of my netgear router
Answer Question
| February 10, 2012 2:54 AM
Netgear router, Router password
my wouter has 6 character password. my iphone doesn’t take less than 8 character. I need to change the password of my netgear router
Answer Question
| February 10, 2012 2:54 AM
Netgear router, Router password
deleting older versions of daily reports
how can i delet the older versions of daily reports in P6
Answer Question
| February 27, 2012 12:36 AM
Intel P6
how can i delet the older versions of daily reports in P6
Answer Question
| February 27, 2012 12:36 AM
Intel P6
How do I use a lm048 bluetooth serial adapter?
I would like to connection my serial adapter to my pc, but they are not pairing with eachother. What should i do?
Answer Question
| June 1, 2012 11:38 PM
Bluetooth Devices, serial adapter
I would like to connection my serial adapter to my pc, but they are not pairing with eachother. What should i do?
Answer Question
| June 1, 2012 11:38 PM
Bluetooth Devices, serial adapter
Impact on ID Vault when changing Domain Name
Domino servers upgrading from 8.5.1 & 8.5.2 to 8.5.3(64) on OS Windows/Longhorn/64/6/1. After upgrading we are changing our domain name and renaming some of our servers. Adding CA Process and ID Vault were also requested. I suggested doing the domain name change first, but that is not scheduled for a few weeks and it was suggested [...]
Answer Question
| February 27, 2012 9:10 PM
64-bit Windows 7, ID Vault, Lotus Domino 8.5.3
Domino servers upgrading from 8.5.1 & 8.5.2 to 8.5.3(64) on OS Windows/Longhorn/64/6/1. After upgrading we are changing our domain name and renaming some of our servers. Adding CA Process and ID Vault were also requested. I suggested doing the domain name change first, but that is not scheduled for a few weeks and it was suggested [...]
Answer Question
| February 27, 2012 9:10 PM
64-bit Windows 7, ID Vault, Lotus Domino 8.5.3
Creating PDF for Arabic code page 420
I am creating PDF files with CVTSPL2PDF and it works fine. Howoever I now need to create a PDF file for arabic Code Page 420 but i can’t (Important characters in creating a PDF file) How do I get around this? Is there a way to specify in the PDF file that on AS400 to add [...]
Answer Question
| February 27, 2012 7:37 PM
AS/400 V5R3M0, PDF AS/400, PDF Files
I am creating PDF files with CVTSPL2PDF and it works fine. Howoever I now need to create a PDF file for arabic Code Page 420 but i can’t (Important characters in creating a PDF file) How do I get around this? Is there a way to specify in the PDF file that on AS400 to add [...]
Answer Question
| February 27, 2012 7:37 PM
AS/400 V5R3M0, PDF AS/400, PDF Files
Can SCCM capture the monitor resolution of remote computers?
Have 40,000 computers deployed and new to SCCM. Is it possible to capture the monitor resolution for all systems? Have an application that needs a higher resolution.
Answer Question
| February 27, 2012 7:32 PM
Monitor resolution, SCCM 2007
Have 40,000 computers deployed and new to SCCM. Is it possible to capture the monitor resolution for all systems? Have an application that needs a higher resolution.
Answer Question
| February 27, 2012 7:32 PM
Monitor resolution, SCCM 2007
Can I use SQL to delete a couple record from a member of a physical file?
I have a physical file that have multiple member and I delete a couple records from one of the member. I’m not sure if I can use SQL to do it. I’m using DFU to remove records now. Thanks!!
Answer Question
| February 27, 2012 6:28 PM
AS400 DFU, AS400 iseries, SQL
I have a physical file that have multiple member and I delete a couple records from one of the member. I’m not sure if I can use SQL to do it. I’m using DFU to remove records now. Thanks!!
Answer Question
| February 27, 2012 6:28 PM
AS400 DFU, AS400 iseries, SQL
adding rounded numbers in Excel
How do you add rounded numbers and get the addition of the rounded number shown not the actual number .125 displayed as .13 .125 displayed as .13 .125 displayed as .13 I want to use the auto sum of .13+.13+.13 and have the cell display .39 NOT .38
Answer Question
| February 27, 2012 6:00 PM
Excel 2010 functions, Microsoft Excel 2010
How do you add rounded numbers and get the addition of the rounded number shown not the actual number .125 displayed as .13 .125 displayed as .13 .125 displayed as .13 I want to use the auto sum of .13+.13+.13 and have the cell display .39 NOT .38
Answer Question
| February 27, 2012 6:00 PM
Excel 2010 functions, Microsoft Excel 2010
Query Engine Error – If tables are already linked then join type cannot change
I recevied this error when I added a table to an exisiting report. I didn’t change any joins.
Answer Question
| April 11, 2012 4:15 PM
Crystal Report, Query Engine error
I recevied this error when I added a table to an exisiting report. I didn’t change any joins.
Answer Question
| April 11, 2012 4:15 PM
Crystal Report, Query Engine error
Capture Port connections on iSeries
Hello, I am in need of some monitoring. I need to know all JDBC / ODBC connections coming into our iSeries on Port 9471 (Database Access – SSL). Does anyone know of any way to capture this info? Thanks for any assistance! bgg
Answer Question
| February 27, 2012 3:47 PM
AS400 iseries, iSeries connections, JDBC AS400
Hello, I am in need of some monitoring. I need to know all JDBC / ODBC connections coming into our iSeries on Port 9471 (Database Access – SSL). Does anyone know of any way to capture this info? Thanks for any assistance! bgg
Answer Question
| February 27, 2012 3:47 PM
AS400 iseries, iSeries connections, JDBC AS400
