DSXchange

Raj I am not sure if I understood the problem correctly. Are you getting an error when you are writing to a unix file??? Where do you get error 2 Err2 : APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090 Why you want to us...

Rich For the problem about the scratch disk File_Set_5: When checking operator: No nodes with disk in "export" resource pool; using default disk pool instead You can add LFS or FS in your resource line in the config.apt file resource disk "/opt/apps/Ascential/DataStage/Datasets" ...

Can you do a
type CC or whcih CC and make sure your compiler path is right??

/opt/SUNWspro/bin/CC

Raj
Welcome aboard.
Can you please give more info?? Is it happening in the source or target table?? Spilt the job into two and try to identify where it happens. Check the select query using command center.

If you are looking for a sample buildop look at the following posting
viewtopic.php?t=85975&

First make sure your data is right. What is happening to the last two bytes??

Did you try exporting the LICENSE_FILE as a variable in UNIX?? Find out where the license file is and export it as a variable. Hope this solves your problem. In case you are not able to solve this let me give you a small tip. When user A compiles , B can not use the copiler. Even after A has stopped...

However when you rename a job , the job goes into not compiled state and also the logs get purged. As Ray said the same RT_LOGnnn will be used. But old entries will be wiped out. That is the reason why you wont be able to rename a job when the log window in director is open for that job.

You can not have same job name for two jobs in the same category. Can you post the job and category names of the two jobs please??

Rich OK. When you cat your fileset or lookupfileset file in unix you can see exactly the location of the data. If your intention is to free space by deleting unwanted filesets and lookup filesets then you can delete the actual file which are pointed by the fileset --Orchestrate File Set v2 --LFile n...

Here is a crude nonelegant way in case you just want to do it anyway.
Generate reports for all projects and store in a windows folder.
Do you search with column name in the text string.

Rich I ried again to delete some more filesets using orchadmin command. I could delete many of them but not all. I am getting the same errors as you were getting. It is not documented anywhere that filesets can be deleted using orchadmin, but I thought it would work because I could delete some of th...

Sudharshan
Please check your syntax again. Probably you left out a ( or some other character.

Another way of addressing the problem would be to load into empty work/staging table. From staging/work table to target (actual ) table could be done fully by oracle. (Using a package ). That works great for us with huge volumes.

It is still there. It is an implicit substring
DSLink3.FIELD_NAME[start,length]