DSXchange

dsxuserrio

I think APT stands for Applied Parallel Technologies (which was later changed to Torrent)

dsxuserrio

Try stopping the services and starting them again in the following order. For Websphere use start-> programs ->Websphere->App Server->profiles->default->stop or start. Wait till it completes. For others you can use services.msc Stop 1. DSRPC Service 2. DataStage Telnet Service 3. DataStage Engine Re...

dsxuserrio

It is possible that the control file (.ds) is still there, but the actual data has been deleted. View the data/Try an orchadmin dump <dataset> to see if the data is still there.

When was this dataset created? After creation did you make any hardware/node changes?

dsxuserrio

Murthy
You can do one of two things.
1. Use Windows 2003 for client. Install VMWare and on the virtual machine install SUN OS and use this as server.

2. Install client and server on Windows 2003.(If it is for single user like practicing or testing the tool).

dsxuserrio

Laiko Until IBM comes up with a feature to integrate check in/check out with IDE,you may have to live with exporting DSX files and version them. You can export several datastage jobs ( all jobs in an iteration) into a single dsx. That way release and deployment may be easier. We use subversion. Thanks

dsxuserrio

Here are the Env variables. APT_COMPILEOPT : -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- APT_COMPILER : cxx APT_LINKER : cxx APT_LINKOPT : -s -W/dll -W/base:0x50000000 -W/Zc:wchar_t- I also removed -W/Zc:wchar_t- from APT_COMPILEOPT and APT_LINKOPT and restarted datastage services. Previ...

dsxuserrio

Hello We installed IBM Websphere Datastage 8.1 and ran into transformer compilation problem. All prerequisite software have been installed including VC++ Express 2008, Windows Platform SDK for 2003. Still we are experiencing transformer compilation problem. Pointing to bad compiler configuration. We...

dsxuserrio

If it is DEV or TEST environment, it could also be due to usage of different config files. Use Orchadmin describe or dataset management to see if same config file was used by different users.

Thanks

dsxuserrio

I am reading several fields as varchar and in the first transformer I just choose the data type as decimal 15 and everything worked fine as expected. The max I had to do was in the transformer use IF IsNull(filed) Then 0 Else filed But for only one field I could not get away with this. I had to use ...

dsxuserrio

I think the raw data comes with different input formats. As suggested by other users create a custom stage which reads the input format as an xml file. Let the custom operator parse the input based on the xml file and produce outputs in different ports .(Output datsets from C++ runlocally method) Th...

dsxuserrio

Pavan
Try to copy the existing job as a newjob.
Test to Test1.

Delete Test.
Rename Test1 back to Test. Then compile and run.

Hope this helps.

Thanks

dsxuserrio

Looks like it is an adhoc requirement before close of business before going home. You can try this l $DSHOME/DSEngine/bin/dsjob -jobinfo $PROJECT $JOBNAME | grep "Job Status" Use a sleep and repeat every 10 seconds. If the result is Run With Warnngs " or whatever you decide accordingl...

dsxuserrio

Please try this

Code: Select all

#!/bin/ksh
FILENAMELIST=$1

PROG=`basename $0`

while read FILENAME discard
do
echo "Deleting $FILENAME"
rm -f $FILENAME
done < $FILENAMELIST
~

Thanks

dsxuserrio

Hi learnpx
To know which config file was used to create the dataset use the following command

Code: Select all

orchadmin describe -c  test.ds

Thanks

dsxuserrio

Sudhirmah Thanks, I have a seq. file with record lenth of 800KB & it is having around 12m records. I want to load this file parallely. Currently i am doing a split on unix and loading the files in parallely. is there a better way using PX to load the file in parallel without doing split on unix....

DSXchange

Search found 81 matches

Transformer Compiling problem

Varchar to decimal -