DSXchange

Try using dos2unix command after sftp'ing the file from script

Hi, Is there a way to find the parent process for ORCHESTRATE Job: Parallel_testjob User: test The pid for the job is 32655 and the ORCHESTRATE is 32730, is there a way to find out the pid 32655 created the ORCHESTRATE process 32730. The reason for this in production, there are some run away jobs, n...

Yes, each ODBC Enterprise stage refer to seperate tables.

Hi, The job design looks like /--------> Transformer ---> ODBC | external Source Stage --> XML -----> Transformer ---> ODBC | |\--------> Transformer ---> ODBC |\--------> Transformer ---> ODBC |\--------> Transformer ---> ODBC |\--------> Transformer ---> ODBC \--------> Transformer ---> ODBC All t...

We changed the ulimit value, after that we are not getting these errors

Yes for some projects it gave me the right answer, for some it gave me the dates which were modified (not created)......

I guess this is the only way, we can find the project created date for some project but not for all.

Thanks for the info.

I got those information by entering those many characters while creating the job.
In Version 8.x in table the datatype is Nvarchar2 .

Thanks for the reply. In project folder, ls -cl gives: $ ls -l VOC -rwxrwxr-x 1 dsadm dstage 260096 Mar 18 14:45 VOC $ ls -cl VOC -rwxrwxr-x 1 dsadm dstage 260096 Mar 18 14:45 VOC where, -c with -lt: sort by, and show, ctime (time of last modification of file status information) with -l: show ctime ...

Thanks for the reply.. Yes, I am confused..... I am not sure the open VOC is giving me the right value[or am I extracting the right value] Is the ProjectName=@ACCOUNT should be added at the beginning(as present in the code) -- if yes still gives me the current date time in the output. To elaborate.....

I changed from @ID to @ACCOUNT still no difference Call DSExecute("UV", "LIST.ITEM UV.ACCOUNT WITH @ACCOUNT='PROJECT_TEST' ", Output,SystemReturnCode) Output: FileMode~ 33277~ DATE_LAST_MODIFIED~ 02:02:30pm~ TIME_LAST_MODIFIED~ 02/25/09~ TIME_DATE_LAST_STATUS_CHANGE~ 50550~ DATE_...

Could you please help in getting the information regarding dynamic array $INCLUDE DSINCLUDE JOBCONTROL.H OPEN 'VOC' TO test.arr THEN PRINT "File Opened" ELSE ABORT STATUS stat FROM test.arr THEN PRINT stat field5 = stat<5,1,1> field15 = stat<15,1,1> field15= Oconv(field15, "MTHS"...

Thanks for the queries For LIST.ITEM UV_SCHEMA WITH SCHEMA_NAME='PROJECT_TEST' Output: PROJECT_TEST 001 23456 002 /Projects/PROJECT_TEST For LIST.ITEM UV.ACCOUNT WITH @ID='PROJECT_TEST' Output: PROJECT_TEST 007 DataStage\7.5\<<HOST_NAME>>\8117 011 /Projects/PROJECT_TEST I tried to look into the fold...

I see only these information in the UV_SCHEMA table

Schema. PROJECT_TEST
Owner.. 323434
Path... /opt//Ascential/DataStage/DSEngine/sql/project_test

is there any other information I should have seen?

Hi, How to know when was project created?... There was a similar post... Question Based on this post Can anybody help me to understand, how to get the value for field #7. When I did LIST.DICT UV.ACCOUNT Type & Field......... Field. Field........ Conversion.. Column......... Output Depth & Na...

As you are already using the script, you can do this in two ways. 1) To answer your case 2, you are placing the file in etl/Projects/xxx/ftpfolder/input [I assume that you will have only file with filename FILE*] so after sftp if [ `wc -l etl/Projects/xxx/ftpfolder/input/FILE* | awk '{print $1}'` -e...