Earlier record’s Field in Crystal Record XI
Hi….how r u all ?I having problem with my reports.My record selection is based on the “Date” Date ChildrenName Current Weight Previous Weight 15-02-2008 Hein 15.8 15.0 Adam 14.8 15.2 If i m selecting the Date 15-02-2008 ,all the Children’s who weighed on 15-02-2008 should be displayed so i grouped it based on Date.Here the [...]

Answer Question   |  March 17, 2008  7:48 AM
Crystal Reports XI, Database programming

Tagged text in Windows to be inserted into Db2 Clob column on Mainframe
I have a string-combinatino of rich text and tagged test: ex: “test msg <p><STRONG></P>” on Windows machine. How i can insert data ‘AS IS’ without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

Answer Question   |  March 14, 2008  7:48 AM
CLOB, DB2, SQL

Maximo – passing current user as report parameter
Hi, I am using Maximo 6.2.1 and Actuate 8. How can I pass the current (logged in) user as a report parameter? Thanks in advance, David

Answer Question   |  March 13, 2008  2:29 PM
Actuate, Maximo

Differences between synchronous and asynchronous data transfers
What is the difference between a synchronous and an asynchronous data transfer?

Answer Question   |  March 14, 2008  8:59 PM
Asynchronous Transfer Mode, Data transfer, Networking, Synchronization, Synchronous transfer mode, Telecommunications

Linking SQL Server databases to create DTS packages
I want to create a DTS package in SQL Server for the following problem: 1. Table T1 in Database DB1 in server1. 2. Table T2 in Database DB2 in server2. 3. Table T3 in Database DB3 in server3. The DTS package will be created in DB3. I need to copy data from T1 and T2 [...]

Answer Question   |  March 12, 2008  10:20 PM
Business Intelligence, DTS, SQL Server

DB2 image copy that is no longer in SYSCOPY on zOS operating system
We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the [...]

Answer Question   |  May 3, 2010  5:27 PM
DB2, SYSCOPY, z/OS

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import
If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb [...]

Answer Question   |  March 11, 2008  6:34 AM
Export utility, Oracle 10g, Oracle 8i

Hyperion Planning and AAS
I just took over the Hyperion Desktop administration in the last few months. I am still learning the systems and studios to function appropriatley with Hyperion products. I have been working with IT on data transition information, but we have both come to a dead end with this problem. Whenever I move a child entity [...]

Answer Question   |  March 10, 2008  7:18 PM
AAS, Entity-Relationship Model, Hyperion, Oracle, Planning

SAP Idoc Paytext FIIKONTO (E1IDB02 BB) and FIIKNAM2 fields
Hi, Can anyone help me. We have an issue regarding the values that are being registered in FIIKONTO and FIIKNAM2 fields of our payment IDOCs… We are using a vendor that has a value in the Reference details in vendor master – payment tab. This vendor has bank details for two countries, one in US [...]

Answer Question   |  March 10, 2008  12:22 PM
FIIKNAM2, FIIKONTO, iDoc, SAP, SAP FI

Can ISPs or the company that issued a Blackberry to me track my internet history?
I use my Blackberry in place of a wireless card for my laptop (tether feature). I connect to the internet using Verizon’s Wireless Broadband service. I would like to know if Verizon or the company that gave me the phone can track or know what I am looking at when I’m using the tether feature. [...]

Answer Question   |  April 29, 2011  3:05 AM
BlackBerry devices, BlackBerry Internet Service, history, IP addressing, privacy, Wireless broadband, Wireless carriers

From Supplier Enablement to SAP SRM?
I currently hold the position of Supplier Enablement, Functional Consultant and my primary functions is working with suppliers and buyers during e-Catalog implementations using a catalog hosting application system. Other duties include help desk phone support , trainings, Content Management by cleaning data, project management, etc. My question is, if I want to move to [...]

Answer Question   |  March 6, 2008  4:14 PM
Catalog software, Content management applications, Procurement, Purchase Order Management, Supplier relationship management, Supply chain management applications

iDocs for GL accounts
I want to sent the balance of a GL account [FS10N transaction] via iDoc to a Biztalk server. I didn’t find any iDoc to solve this problem. thak you, vic

Answer Question   |  March 6, 2008  12:26 PM
BizTalk, iDoc

DB2 Load Utility
If I run the DB2 LOAD utility LOG NO REPLACE is all the data externalised to DASD immediatley ? I.e. if I ran DSN1COPY against the underlying VSAM dataset immediately (without stopping pageset) would all rows be copied ?

Answer Question   |  December 7, 2009  4:59 PM
DB2, DSN1COPY, LOAD

How to Force a Joblog.
It used to be that a JOBD with Message logging of 4 0 *seclvl would always force a joblog. This has changed in V5R3. My Sarbanes Oxley requires a joblog for superusers and above. How can I force a joblog to be produced at signoff for these user types?

Answer Question   |  April 8, 2010  2:18 PM
AS/400 security, Job Management, SOX

Appointment Conflict
As a new administrator, I have created a basic calendar for users to schedule a conference call number. This calendar allows me to repeatedly schedule the same date and time. I do not want this to be allowed. What script do I use to not allow appointment conflicts to occur and where do I put [...]

Answer Question   |  March 4, 2008  4:52 PM
Calendar, Conflict, LotusScript, Scheduling

DB2 to Text File Conversion and Transfer
I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

Answer Question   |  March 3, 2008  2:50 PM
AS/400 DB2, DB2, DB2 Implementation, iSeries database

Mainframe Career – is it possible for me?
hello, I have been working for a MNC in India for the past 2 years.My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files.I also write simple SQL queries for DB2.I am right now in a stage where [...]

Answer Question   |  July 31, 2008  5:51 AM
CICS, COBOL, DB2, Developer, Mainframe, Mainframe jobs, SAS, VSAM.MVS

Idoc orders05 inbound, Assignment field mapping?
Idoc orders05 inbound, I am trying to bring the assignment field(zuonr) i noticed E1EDK02 QUAL = 017 but if I add it to my test idoc within we19 it doesn’t pull into sales order. How can I do it?

Answer Question   |  August 8, 2008  1:00 AM
iDoc, ORDERS05, SAP

Crystal report – how to link fields
I have to make a report that links two fields after some string manipulation like mid({field1}, 3) = field2. Is there any way to do this? I have attempted a subreport, but that is a left outer join and doesn’t limit the report results. I’m sure that can be done in the select expert, but [...]

Answer Question   |  February 26, 2008  9:21 PM
Crystal Reports

How a router helps in delivering and connecting two networks at different places
How does a router help in delivering and connecting two networks at different places, say for example one sends some data from India to a friend in the USA and they are working on different machines: one is working on a PC machine and the other on a MAC machine?

Answer Question   |  February 27, 2008  9:11 PM
Data transfer, Mac, Networking, PC, Routers