DSXchange

I have posted the topic in parallel forum

Regards,
ssunda.

Hi, I am executing a shell script which returns value 0 or 1 based on some conditions, using DSExecute function in a routine(transform function) Ans=Output<1> worked fine and i got the required output. Because of some error in the script, the script is now returning some error statements along with ...

Hi Chullet, Ray I tried both options : Count function and redirecting error messages to some file or /dev/null Both of them are not working. Redirecting output is not working some times. When I had an error of missing some files, it redirected all error messages except one message . I tried using th...

Hi, Forgot providing example of output from the script. When we got error, the output was as follows: tail: cannot open input error: No such file or directory on file /opt/ofa/logs/tgt_testA.log 1 I can get the last line of output using Ans=Output<3> . But next time if the error differs, and i have ...

Hi, I am executing a shell script which returns value 0 or 1 based on some conditions, using DSExecute function in a routine(transform function) Ans=Output<1> worked fine and i got the required output. Because of some error in the script, the script is now returning some error statements along with ...

Hi csrazdan,

Thank you for the reply.

When I did not add the parameter APT_ORACLE_LAOD_OPTIONS , by default it was taking SKIP_INDEX_MAINTENANCE=TRUE.

But the problem of rebuilding indexes again occurs and I have to do it using another userID, which I am not supposed to.

Thanx,
ssunda.

Hi,

Yes John, You are right.I have checked for privileges and the user i am using is not having privilege to alter the index.

Is there any way to skip index maintanance so that I can use the same user ID?

Hi, My requirement is to truncate a table and then load data. I tried using Write Mode=Truncate and Write Method=Load. It gave the following error and the job got aborted. Indexes on table 'xxx' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes ...

Hi Ray,Chulett,

Thanx a lot for the solutions. I used record terminator as DOS-terminator and now i have proper text files in my mails.

regards,
ssunda

yup, I dont want this group to disappear.

Hi all,

I set the property "first name column names= true", and the column names along with data is being written to the reject file. So, I dont think we need to hard code the column names again. Correct me if im wrong.

Thnx all for the replies.

regards,
ssunda

Hi

Thnx Ray and Chulett for the relies. I will try them out now and get back to u.

Ray, only a part of ur post is visible. I am not a charter member. Plz post it again, so that I can read the solution u gave.

regards,
ssudna

Hi all, sorry for replying so late. I dont have reject link from sequential file. Reject links are from stages like transformer, lookup. For one of my files I have 150 columns, so hardcoding the column names is difficult. Iam not reading from files which have column names, instead I am trying to wri...

Hi chulett, You are right. we are creating files on unix and emaling to windows. I think I will not be able to create DOS files as the server on which our Datastage is working is on unix operating system. Any other options that will enable us to view the data properly?? thanx in advance, regards, ss...

Hi,

I have a requirement of having column names in addition to data in a file.
Any inputs as to how to do this will be of great help.

regards
ssunda