File transfer from V5R4 to V4R5
Need to transfer files from the iSeries V5R4 to AS/400 V4R5. Cannot restore a save file further back than 2 releases. Please help

Answer Question   |  August 12, 2008  2:04 PM
File transfers, iSeries, V4R5, V5R4

job problem
i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it’s created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => ‘DropIp_test’, job_type => ‘plsql_block’, job_action => ‘begin dbms_output.put_line(”DELETE EXPIRE : this [...]

Answer Question   |  August 11, 2008  11:21 AM
DBMS_SCHEDULER, PL/SQL

SAP orders idoc issue
Hi, Please resolve my below issues. 1) As part of my inbound interfaces, i have to include partners ( Contact person or ship to ) Email information in orders05 IDoc and using user exit needs to pass in sales order. is there any place holders for EMAIL info in idoc and userexit ? 2) I [...]

Answer Question   |  August 11, 2008  9:51 AM
iDoc, ORDERS05

Located near Hickory
Having difficulty converting from Director to Server for Windows and using expedite to pull from GXS Mailbox, anyone using Getran Server for windows near Hickory, N.C.?

Answer Question   |  August 7, 2008  3:21 PM
Gentran, Gentran Server

how to find first record from group in crystal report with .net
We have grouped according to our Accoutname field from databse. now we want to fetch only the first record from the group as we want one condition to be applied only on first record of the group and for rest another condition.this we want in every group not only one!!

Answer Question   |  August 7, 2008  10:48 AM
.NET development, Crystal Reports, Database reporting

Actuate 8 enterprise reporting tool,Text files
Hello, Am currently using actuate 8 as a reporting tool.The major problem encountered is to deal with flat files with fields separated with other delimiters other than commas.For example I encountered a flat file delimited with back slash am unable to tackle.Is there any way out in Actuate 8 or other programming languages? Please help.

Answer Question   |  August 29, 2008  10:44 AM
Actuate, Actuate 8, Database reporting, Flat files

jasper ad-hoc report takes more time
problem is that jasper ad-hoc reports take more time how to resduse it ,some time it take less time but some time it takes more than expected what is the solution of that . If may be any problem please tell me as soon as possible.

Answer Question   |  August 7, 2008  10:23 AM
Business intelligence software, Data mining/analysis, JasperServer

Printing Documents
I am printing documents that I have designed in DOC1. The data comes from COBOL programs that I have written that gather information from DB2. The pages are not printing in the center of the page, so it is cutting off some information at the bottom and the right. I got a lead that this [...]

Answer Question   |  August 13, 2009  5:00 PM
COBOL, DOC1, JCL

ODSObject to Infocube
TransactionData Loading from ODSobject to Infocube Manually from FlatFile

Answer Question   |  August 6, 2008  3:45 PM
Flat files, InfoCube, ODSObject

send data from sqlserver to ms access
i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .

Answer Question   |  August 1, 2008  1:48 PM
Data transfer, Microsoft Access, SQL Server migration, VB.NET

Data Pump REMAP_TABLE parm
I’m trying to use the remap_table parm in the impdb phase of data pump. I’ve done an expdb from a production database and I’m trying to copy it into a different schema, tablespace and table. The table on the receiving database is set up the same as the table in production. When I try to [...]

Answer Question   |  July 31, 2008  6:05 PM
Data Pump

How can I map a pc keyboard key to 5250 emulation and have a dup key
I have AS400 program doing data entry. The users want to use a dup key to duplicate data entry into a subfile from one line to next. How can I map a pc key to be a dup key?

Answer Question   |  July 30, 2008  3:31 PM
5250 session, AS/400 database, Data entry

Application transfering
Do you know how a system (a Veritas Cluster System to be exect) automatically transfers an application from the primary server to the standby server in the case of a failure in primary server? Does the target need to pay a license for both servers in this case?

Answer Question   |  July 30, 2008  2:40 PM
Cluster, License, License software, Primary Server, Standby Server, Transfer, Veritas

file transfer PC to z/OS Host large EBCDIC
I’m doing a file transfer from PC to Host 7M record size 24576 EBCDIC format. Failed after a few seconds. What type I should use and how to extend the time? Please help?

Answer Question   |  July 30, 2008  3:26 AM
EBCDIC, File transfers, z/OS

Report Query
Can I run a query in peoplesoft if I don’t have access to query manager?

Answer Question   |  July 28, 2008  7:59 PM
PeopleSoft, Query Manager, Reports

Explaining features in SQL Server 2005
I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

Answer Question   |  July 28, 2008  3:42 PM
Data analysis, Data integration, SQL Server 2005

Passing Current Thread culture to Crystal Reports
I have an .net application which uses System.Threading. Thread.CurrentThread. CurrentCulture to set the right dateformats throughout the app, This culture which has date formats can be modified any time by the user. How can i pass this current thread culture date formats to Crystal report field objects. I have requirements not to use the Formula [...]

Answer Question   |  June 24, 2010  4:55 PM
.NET applications, Crystal Reports

How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

Answer Question   |  July 29, 2008  8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS

.NEt Cognos Connectivity
Hi, i need to connect Cognos with .Net how could i connect then generate reports and then save it in some other format like HTML or EXcel through .NET. Regards, Neha

Answer Question   |  July 25, 2008  7:29 AM
.NET, .NET applications, Application integration, Cognos, Interoperability

Spss data analysis
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]

Answer Question   |  July 25, 2008  1:07 AM
Business Intelligence, Data analysis, SPSS