how to do SFTP on AS400 to UNIX given http:// address
I am given a http:// address and would like to send file to that address from the AS400. Was told I can use SFTP. What is the syntax.
Answer Question
| April 1, 2012 5:05 PM
AS/400, SFTP
I am given a http:// address and would like to send file to that address from the AS400. Was told I can use SFTP. What is the syntax.
Answer Question
| April 1, 2012 5:05 PM
AS/400, SFTP
Dynamic view creation in lotus notes….
Hi, I created a view at run time using lotus script. But I am not able to open that view just after its creation. I need to close the application and reopen it, then only the newly created view is getting it the work space object. Following is my code, Please help me…… Dim s [...]
Answer Question
| April 10, 2012 2:20 PM
Lotus Notes View, Lotus Script
Hi, I created a view at run time using lotus script. But I am not able to open that view just after its creation. I need to close the application and reopen it, then only the newly created view is getting it the work space object. Following is my code, Please help me…… Dim s [...]
Answer Question
| April 10, 2012 2:20 PM
Lotus Notes View, Lotus Script
SQL/400
What is wrong in the *BLANKS in the following code WHERE (EMPID=:*BLANKS OR EMPID=:EMPID)
Answer Question
| March 30, 2012 9:43 AM
AS/400, AS/400 SQL
What is wrong in the *BLANKS in the following code WHERE (EMPID=:*BLANKS OR EMPID=:EMPID)
Answer Question
| March 30, 2012 9:43 AM
AS/400, AS/400 SQL
Authenticating server access
I want to provide authorized acces (identified users )to a public erp server over internet. I am considering to implement rsa using VPN client. how can I allow access to specified users using above technology or any other? Appreciate your help.
Answer Question
| May 27, 2012 9:18 AM
RSA SecurID, VPN Client
I want to provide authorized acces (identified users )to a public erp server over internet. I am considering to implement rsa using VPN client. how can I allow access to specified users using above technology or any other? Appreciate your help.
Answer Question
| May 27, 2012 9:18 AM
RSA SecurID, VPN Client
SB Led on the system board of a HP ProLiant DL380 G4
One of the servers I manage reports a health problem wich i discovered on a routine led-status inspection. This is something i do regularly so this problem is reasonbly fresh. Opon pulling it out of its rack and opening it I quickly found the SB led on the system board glowing amber therefore beeing a [...]
Answer Question
| March 31, 2012 9:15 AM
HP ProLiant, RAM, SB Led
One of the servers I manage reports a health problem wich i discovered on a routine led-status inspection. This is something i do regularly so this problem is reasonbly fresh. Opon pulling it out of its rack and opening it I quickly found the SB led on the system board glowing amber therefore beeing a [...]
Answer Question
| March 31, 2012 9:15 AM
HP ProLiant, RAM, SB Led
How to get caller program list by Calle program
Let assume that I have a program TESTR but i dont know how many program is calling to TESTR program. Is there any API or System file to get this. Thank You.
Answer Question
| April 3, 2012 8:02 AM
AS/400 V6r1m0, AS400 iseries
Let assume that I have a program TESTR but i dont know how many program is calling to TESTR program. Is there any API or System file to get this. Thank You.
Answer Question
| April 3, 2012 8:02 AM
AS/400 V6r1m0, AS400 iseries
OPNDBF then CLOF – the joblog indicates that the file was closed but it still appears in dspjob #14
Member/ Record File I/O —-Open— File Library Device Format Type Count Opt Shr-Nbr B99FL161 XYZISDTA B99FL161 B99FX161 LGL 4 IO YES 3 When the NBR is > 1 the close only reduces the NBR by 1 – and the file still appears in the joblog. When the OPNDBF is used to actually [...]
Answer Question
| March 30, 2012 8:07 PM
AS400 iseries, CLOF, OPNDBF
Member/ Record File I/O —-Open— File Library Device Format Type Count Opt Shr-Nbr B99FL161 XYZISDTA B99FL161 B99FX161 LGL 4 IO YES 3 When the NBR is > 1 the close only reduces the NBR by 1 – and the file still appears in the joblog. When the OPNDBF is used to actually [...]
Answer Question
| March 30, 2012 8:07 PM
AS400 iseries, CLOF, OPNDBF
Lotus notes 6.5 Delegation
I delegated a meeting to another individual but need to add additional attendees without resending the appointment to all Attendees on the original meeting request.
Answer Question
| April 9, 2012 7:34 PM
Lotus Notes 6.5, Lotus Notes mail rules
I delegated a meeting to another individual but need to add additional attendees without resending the appointment to all Attendees on the original meeting request.
Answer Question
| April 9, 2012 7:34 PM
Lotus Notes 6.5, Lotus Notes mail rules
STRPCCMD leaves pop-up open
How can I stop the STRPCCMD from leaving the pop-up window open? I’m using the PAUSE(*NO) parm in my CL program and it still leaves the pop-up on the screen.
Answer Question
| April 3, 2012 6:27 PM
iSeries V6R1, STRPCCMD
How can I stop the STRPCCMD from leaving the pop-up window open? I’m using the PAUSE(*NO) parm in my CL program and it still leaves the pop-up on the screen.
Answer Question
| April 3, 2012 6:27 PM
iSeries V6R1, STRPCCMD
File Server
Am using a desktop and have 5 laptops on the network and i want them to share files on the desktop. I dont want to install any server software. How do i create my Window Vista desktop into a file server.
Answer Question
| March 30, 2012 3:44 PM
Windows Vista
Am using a desktop and have 5 laptops on the network and i want them to share files on the desktop. I dont want to install any server software. How do i create my Window Vista desktop into a file server.
Answer Question
| March 30, 2012 3:44 PM
Windows Vista
How to use “OR” condition in IF ELSE statement
Hi, How to compare multiple element values in if else condition of XML? Is there any syntax like “OR” example if the element is “NAME” and it has values as (‘RAMA’,'SHAYAM’,'SUNNY’,'DAVID’)? Is there anything like <?if:NAME=’RAMA’ OR ‘SHAYAM’ OR ‘SUNNY’?> I want to use this in if else statement ..for every value like ‘RAMA’, ‘SHYAM’ [...]
Answer Question
| September 17, 2012 1:52 PM
Microsoft Word 2007, XML
Hi, How to compare multiple element values in if else condition of XML? Is there any syntax like “OR” example if the element is “NAME” and it has values as (‘RAMA’,'SHAYAM’,'SUNNY’,'DAVID’)? Is there anything like <?if:NAME=’RAMA’ OR ‘SHAYAM’ OR ‘SUNNY’?> I want to use this in if else statement ..for every value like ‘RAMA’, ‘SHYAM’ [...]
Answer Question
| September 17, 2012 1:52 PM
Microsoft Word 2007, XML
Getting last 6 entries for each person
Hi everyone, I am trying to create a query that pulls the last 6 exam scores for each of the operators at the plant I work at. I have a table that has the last 2-3 years worth of data. The current query I have just organizes the data without filtering the last 6 entries, [...]
Answer Question
| April 11, 2012 1:41 PM
Microsoft Access 2003, Microsoft Access 2003 forms
Hi everyone, I am trying to create a query that pulls the last 6 exam scores for each of the operators at the plant I work at. I have a table that has the last 2-3 years worth of data. The current query I have just organizes the data without filtering the last 6 entries, [...]
Answer Question
| April 11, 2012 1:41 PM
Microsoft Access 2003, Microsoft Access 2003 forms
unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
How to connect my computer to SQL server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
Selection of Friday Date
In lotus designer how we can Select only friday dates in Calender/Time control? (for eg. if we select tuesday date corresponding week’s friday date should be selected.)
Answer Question
| May 10, 2012 10:20 AM
Lotus calendar, Lotus Designer
In lotus designer how we can Select only friday dates in Calender/Time control? (for eg. if we select tuesday date corresponding week’s friday date should be selected.)
Answer Question
| May 10, 2012 10:20 AM
Lotus calendar, Lotus Designer
Printer File
I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.
Answer Question
| March 30, 2012 7:32 AM
AS/400, AS/400 Printer File
I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.
Answer Question
| March 30, 2012 7:32 AM
AS/400, AS/400 Printer File
Track SQL Statements run by a specific user through ODBC Connection
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
Schedule Job
Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1 user-user1
Answer Question
| March 29, 2012 6:19 AM
ADDJOBSCDE, AS/400, WRKJOBSCDE
Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1 user-user1
Answer Question
| March 29, 2012 6:19 AM
ADDJOBSCDE, AS/400, WRKJOBSCDE
copying tables to excel
How do I copy a table with more than 65000 records into an excel workbook?
Answer Question
| March 29, 2012 9:36 PM
Microsoft Access 2010, Microsoft Excel 2010
How do I copy a table with more than 65000 records into an excel workbook?
Answer Question
| March 29, 2012 9:36 PM
Microsoft Access 2010, Microsoft Excel 2010
Order column in pivote table from vba
I need help to make this, i try with PT4.PivotFields(“Category”).AutoSort xlDescending, “Ventas” but not sorting. Please helpme, With ActiveSheet.PivotTables(“PivotTable5″).PivotFields(“Ventas”) .Orientation = xlDataField .Position = 1 .Function = xlSum .NumberFormat = “#,##0″ .Caption = “Sum Of Ventas” End With ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _ .AutoSort xlDescending, “Sum Of Ventas” [...]
Answer Question
| March 28, 2012 7:15 PM
Microsoft Excel 2007, VBA
I need help to make this, i try with PT4.PivotFields(“Category”).AutoSort xlDescending, “Ventas” but not sorting. Please helpme, With ActiveSheet.PivotTables(“PivotTable5″).PivotFields(“Ventas”) .Orientation = xlDataField .Position = 1 .Function = xlSum .NumberFormat = “#,##0″ .Caption = “Sum Of Ventas” End With ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _ .AutoSort xlDescending, “Sum Of Ventas” [...]
Answer Question
| March 28, 2012 7:15 PM
Microsoft Excel 2007, VBA
