DSXchange

You would do this in a server job or via a server routine.

1. Get a list of all jobs (DSGetProjectInfo())
2. Go through the list and open up each job and see if it is a sequence (DSGetJobInfo(Handle,))
3. Get the job status (DSGetJobInfo(Handle,DSJ.JOBSTATUS)

from the DOS command line try

ping 10.142.193.28
telnet 10.142.193.28 1858

qutesanju:

a) All UVCONFIG assignments are made with commands such as UVTEMP={value}. Check the other assignments before and after and then check your UVTEMP again, if it is missing the path assignment then you have found your error

b) what are you telling us to check?

I just saw that you are working under windows, it has been a while since I've used DS and windows so perhaps those variables are not required. Perhaps someone with Windows could cross-check this.

There is another problem with your command. the "SELECT" verb also exists with the DataStage query language and DS detects the different flavours (DS syntax or SQL syntax) by looking for a ";" terminator in the command, if that is not present then it is assuming the standard Data...

What is your definition of "2 months". If it is "60 days" then you could convert your date to day-of-year, subtract 60, then convert back to a date (checking for negative numbers on the way). If you define 2 months as "same day number 2 months back" then you need to add...

If you turn on APT_DUMP_SCORE for your jobs you will be able to see how many processes each starts. Add up the numbers for all jobs started by your 14 sequences that run in parallel - how many processes do you have and what sort of a hardware configuration do you have (CPUs,Memory)? That is more lik...

"filescan" is not, to my knowledge, a standard UNIX command in any flavor I know of.

The transform function Right('000000000000':In.AD-ACCT-ID,12) on a string.

Yes, you can - but you need to do more programming work than if you used the appropriate DataStage database stage(s).

With the "%e" or "%E" format of DateToString() you can get the numeric day-of-week for a given date, and with "%ddd" you can get the numeric day-of-year for that date. Subtract the day-of-week from the day-of-year and then reconvert to a date using StringToDate() and yo...

Kumar66, A timestamp (and date, time as well as all numeric datatypes) has no format ; thus what you are doing when going from one timestamp to another timestamp is using up CPU but not changing any value at all. All of the 'binary' datatypes are without a format until they are assigned to a string ...

Your picture for the conversion has 10 characters, but your string only holds 8.

p.s. please delete your duplicate post before someone responds to it.

So now you have a corrupt repository, perhaps a discrepancy between the xmeta and DS repositories that cannot be reconciled. If you do a full project export, create a new project and import the file, are the "missing" jobs present? If yes, it might be quickest to just delete that corrupt p...

Narrow the problem down to one job that you see in the director and not designer list. From the director, click on the job in question and then the "Tools -> Designer", does it open up the job in the Designer and, if so, is the job shown correctly and does it appear in the designer list?