DSXchange

So Texas rules huh?
How many showed up, aproximately ???

Actually look at it from a per day basis. Less than 14 cents a day you can get full access. Cheaper than peanuts.

Same here. Want feed back

Ok do this, connect routine activity to a job activity. When you open the 'Value Expression' for the job parameter inside the job activity and right click on it, what do you see. Do you see 'Acitivy Variable'. If you do then choose $ReturnValue from it and you can safely call the UtilityHashLookup()...

In the command prompt of administrator, type LIST DICT DS_AUDIT. That will give you the structure of that table/hashed file. As far as my knowledge goes, i believe the entries in DS_AUDIT stay there for a long time Yes, this table can tell which person edited/deleted which job when. Some developers ...

mab_arif16 wrote:I sequence is calling another sequence in the job activity ,and if it use the option reset if required then run ,will the inside sequence reset .

Yes it will.

Coz i am still learning and getting there.... BTW, my initial sql query is kinda wrong. I had that doubt yesterday, but thought someone would correct it. You really need to write some heavy sql to get this. Following is the query to satisfy the first three conditions Hashed file A and Hashed file B(...

Here are my views, 1) Create Hash file for both files File A and File B Yes, and in account. while creating the hash files. (Q1) Should the keys be a) for File A -> A.KEY, A.col1,...... A.col5 b) for File B -> B.KEY, B.col1,...... B.col5, B.to_pickup as we dont want to loose anything while creating ...

at the unix level you can set the warning level dsjob -run -warn 1 Projectname Jobname -warn 1 will set the warning limit to 1. YOu can specify any number there. And as per the job that aborted abruptly, you need to go in the director, reset it, some more messages will be written to the log file. Yo...

Do a search. This has been covered a lot over here. Start here

Thats all the messages that you can provide us ?
Do a reset and see what other messages show up in your log file.

You mean not bugging us You are not. The invocation ids come into existence when you make a job multi-instance. You can run several instances of a particular job at the same time which is distinguished from one another on invocation id. I suggested to your friend in my other post to use the invocati...

I got your requirement. BTW, you mean count(B.key)=1. As i advised before, load the two files into a hashed file and access them via universe stage Write a sql query on it. something like select A.col1,A.col2,A.col3,A.col4,A.col5,B.to_pick from A INNER JOIN B on A.col1=B.col1 and A.col2=B.col2 and A...

That post was different as mahi_mahi needed to run a second job with each value read from a csv file in the first job. I asked him to load the csv file into a hashed file with an extra column that would be the key a running number incremented sequentially, which will also be the invocation id for th...

That link is not working. Its taking me to a login page and once i login, it dosnt show the topic.