DSXchange

chesterkchu wrote:Hi Aaron,

Try LIST filename WITH columnname = 'value'



Thanks,

Chester

That works but I'm not sure how well it will work with 102 million rows. I tried is on a smaller has file of 2 million and it take about 5 min to return.

Thanks

chulett wrote:Why not 'View Data' and then use the Find option there?

Craig there are over 102 million rows in my hash file this option is not feasible.

Thanks

This only will search if you know the id of the record. I want to know if there is a way to search for a given part of the actual record.

Does anyone know a way to search for a row in a hash file either with a unix command or in Administrator. Basically I want to grep for a row but im not sure how to do this with a hash file.

Thanks

Aaron

Hello, I currently have a job that does a normal lookup and in the look up a have sql that joins a few tables, groups by a key and returns a count (*) for the given key. when I do the normal look up the job returns the correct results, however the input for this job is very small and the look up dat...

I have the following data coming in and I want it to be restructured into the second list of data. I have figured out how to do it with a transform outputted to x amount of links then funneled back together. I want to aviod this becuase in my actual job I have to do this with around 20 fields. Below...

No we are using routine activities to call the jobs

We have a few sequencers where it does not matter if multipe jobs run at the same time. When we try to do this however, data stage only runs one job in the sequence at a time. Does anyone have any suggestions. The sequence looks as follows 3 1 > 2 > > 5 4 All this does is to run 3 then it runs 4 the...

I have a job that converts a char of length 8 to a date. After debugging I realized that some of my input data comes in as a high value of 99999999. I first need to convert those fields that come in as that high date to our default of 99991231 in a char or varchar format. The way i accomplished this...

I am building a hash file that must contain a date in the format yyyy-mm-dd. When I do the seelct statement from my Oracle DB in either a date or timestamp format the field does not populate into the hash file. If I pull the date into my hash file as a varchar is pulls the date in the format dd-MMM-...

Our team has a set of jobs and sequencers in a folder in our project. Is there a way to lock those jobs to just give read only access to that folder or can that only be done at the project level?

We are currently trying to load data into Datastage with a px job. The job runs fine if we run it as a server job with a user defiend query. However when we run it as a px job we get the following warning followed by the following error: main_program: An NLS map <ISO-8859-1> is specified, but NLS_LA...