DSXchange

Chulett.. did you ever find out resolution for this problem... we are facing similar issue and jobs are failing with abnormal termination.. we restarted all the services on the box as IBM instructed and still unable to resolve the issue.. we are able to re-run the jobs once we reset the jobs.. Thank...

Thank you for your answer Ray and Noted the terminology


Thanks
kris

Hi Ds guru's, we use hash files to point to UV and pull the data into our staging area. we have FILE1 source (pointer1) and FILE 2 lookup (pointer 2), In the present design we select all the records from FILE1 and make a lookup with File 2 to find the delta records. is there a better way we can do i...

Hi , We are running into an issue while importing metadata for a .csv file. Version : 8.5 Operating system: Redhat Linux 5.5 While trying to import metadata for a file it aborts and give me the following message Error.Please see log files. Below is the error I found in SystemOut.log file under the f...

Thank you Ray

Hello Guru's, can we do Horizontal sort(sort between columns) in datastage? The source is flat file and target is oracle table. i got data as follows,col1 is the key column. col1,col2,col3,col4,col5,col6 A,2011/01/20,2008/05/18,2009/12/16,1998/96/12,2002/09/19 i need to get the data in the folloing ...

Hi, i got the same error today and it went away after re-run.. do you think we need to do any changes in the setting in datastage to avoid these kinds of errors.. Error reading record PRD_NEW..fifo from file RT_SCTEMP - error number is 1 This is the parallel job. reads the data from flat file and lo...

I am getting the following error while checking a Parallel ..configuration file.

Any input would be great

Error:
Remote shell error accessing host.
rsh -l mkdir -p remote/PROJECT NAME/RT_SCTEMP > RT_SCTEMP/RunRemote_7245.651284.tmp 2>&1
host: name -l NOT FOUND

Hi Ray
I had published the results and so was i able to see the summary of analysis results in both BG and MWB. Not sure why i am not able to see that in DS.

Thanks,

Please find the answers below The Sequential file definition, that was analyzed in IA They are not viewing the data in the tables, they are able to see the analysis information in the imported file definition in DataStage designer. The analysis results can be seen in the "Analytical Information...

Just wanted to let you know that this is for 8.1 release.

Thanks Ray for responding. One of the other teams, were able to view the analysis details which i had listed in my earlier note (which i was able to see from IA and MWB). The team goes to DataStage project Repository-->MetaData Sharing-->Create Table Definition from Shared Table and choose the defin...

Hi I have been trying to view IA published results for a Sequential file definition from DataStage. Unfortunately still have not been able to succeed. Kindly let me know how can i view the results from DataStage. I was able to view the results of this file definition from BG and MWB. It displayed th...

Hi, I am trying to write a script which will export the ds objects along with there dependencies in isx forrmat.The script reads from a text file and get the job names and exports it..But I am running into an issue here.. here is the script synatx i am using.. %ISTOOL_PATH%\istool export -domain XXX...

We are running into an issue while compiling ds jobs imported to a 8.5 environment from 8.0 environment... error message Environment variable '$IDCUserID' defined in job parameters but not defined in project This parameter is actually defined at project level... Also when I am adding the parameter t...