DSXchange

I was trying to shorten the statement. I thought I could use the following

INDEX('ALPS',function(expression,'','~'),1)

My IF statement already is complex.

When a reference record is not found during the lookup for a VarChar record it returns ''. It there a way to change the '' to ~. I am using the INDEX function. INDEX('ALPS', expression, 1). the problem is '' returns 1 from the INDEX call. Not sure why but in order for my INDEX to work, I need to con...

We deleted the files in the Server\Dataset directory and tested a few sequence run. Everything seems to work as it did before.

It's funny because there are ton of Lookuptable files that were left around from previous jobs. We couldn't get ORCHADMIN RM command to work and tried other way. None successful. So since it's a development box, we deleted all files. I am current testing existing jobs that use datasets. So far so go...

Our jobs started to abort this morning due to space issues. After review, we found many files existed under IBM\InformationServer\Server\Datasets. I know that under the Project directory, there is also a directory called Datasets. It doesn't have anywhere near the same amount of datasets. My questio...

The output column seems to be fixed. The output is wrapped. How do I expand the column length?

Thanks

When issuing the following command in administrator;

SELECT NAME FROM DS_JOBS WHERE CATEGORY = '\Jobs\EDW\ICMS'

I would like to write the results into a file for future reference. Is there a way.


Thanks in advance

Both clients need to exist on your local machine. I am not sure how the virtual machine reacts but we have used the MCM on our local machines to access both versions

You will need to create a separate project and put the restricted job in it. There is no facility to restrict jobs within a project

Create a BAT file with the Datastage EXPORT command. If you read the documentation you will find the syntax. It is really simple. You can backup at the Project level

Yes, tried a number of different options. Even tried it on version 8.0.1. We have both versions. Still trying to determine why. What's very strange is, I can't find the ctl file or the fifo.out file.

We are encountering a weird issue with the Oracle Load option in the Oracle EE stage. If we use this option with Sequential Files or Datasets as input, the LOAD option works. It we use an Oracle EE stage as input and an Oracle EE stage as output, no data get loaded. The log shows the number of recor...

I didn't hijack, I was giving my two cents regarding performance. I realize they are two different operating systems but the subject is the same. As for stirring up trouble, no. I would prefer to use datasets. So in summary, I wasn't hijacking the thread. I would figure that Windows and Unix would h...

I apologize, I wasn't clear because I responded to a question asked with a Unix system.

No matter what, should we not get better performance with datasets?

THanks

Answer to two of the questions asked from our Server tech.

First:

The disks are local mounted raid5 and scratch is a local mounted non-raid.

Second:

No... JFS is only on unix.

I hope I was clear that we are running Windows. This may be the reason for most of our issues.