Search found 2886 matches

by qt_ky
Wed Aug 20, 2014 9:31 am
Forum: General
Topic: dsjob -ljobs question Different results in 2 DS projects
Replies: 2
Views: 2945

I posted a sample script with ISD deploy / undeploy commands. http://www.dsxchange.com/viewtopic.php?t=144561 As we build new web services, we add their ISD application names to the ISD stop/start scripts. Detecting ISD applications that are deployed and iterating through a dynamic would be a nicer ...
by qt_ky
Tue Aug 19, 2014 2:36 pm
Forum: General
Topic: dsjob -ljobs question Different results in 2 DS projects
Replies: 2
Views: 2945

I checked on 8.7.0.0 and do not see the ISD jobs reported with the running status. I also do not see the garbled text returned. Instead it's just an empty list.

You can still use the ps -ef | grep ... command to check from the operating system level.
by qt_ky
Tue Aug 19, 2014 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: join vs lookup
Replies: 3
Views: 1616

Then there is also sparse lookup, also documented.
by qt_ky
Tue Aug 19, 2014 6:37 am
Forum: General
Topic: Display Files as date wise like aug 18th,19th,20th data file
Replies: 10
Views: 2985

The Submit button needs a Turing test added. :wink:
by qt_ky
Mon Aug 18, 2014 8:45 pm
Forum: General
Topic: Display Files as date wise like aug 18th,19th,20th data file
Replies: 10
Views: 2985

So, resolved?
by qt_ky
Mon Aug 18, 2014 11:03 am
Forum: General
Topic: Unique random number generation
Replies: 12
Views: 6768

Thanks for sharing. If you run the routine at exactly the same time each day then it should produce the same result each time.

If it also takes the date as a number into the seed, then the result should vary each day, which I am guessing is what you really want.
by qt_ky
Mon Aug 18, 2014 11:00 am
Forum: General
Topic: On what technology is DataStage GUI built ?
Replies: 6
Views: 2008

I suspect a lot of C/C++ but don't know... Java 1.0 was released in 1995. DataStage 1.0 in 1997.
by qt_ky
Mon Aug 18, 2014 10:55 am
Forum: General
Topic: Display Files as date wise like aug 18th,19th,20th data file
Replies: 10
Views: 2985

Did you try this command?

ls -ltr
by qt_ky
Thu Aug 14, 2014 8:29 am
Forum:
Topic: Line Colors in Data Lineage Reports
Replies: 6
Views: 4167

As far as I can tell, the color meanings are undocumented in all versions up through 11.3. I will ask around.
by qt_ky
Wed Aug 13, 2014 8:01 am
Forum: General
Topic: Unique random number generation
Replies: 12
Views: 6768

To generate a truly random numbers, especially from one job run to the next, you can combine the random() function result with an analog value such as the 6 digit microseconds from the CurrentTimestampMS() function. Microseconds are always changing. To ensure that the randomly generated number is un...
by qt_ky
Tue Aug 12, 2014 6:07 am
Forum: Site/Forum
Topic: premium membership ACCESS ISSUE
Replies: 6
Views: 8700

When I renewed, I did not recall seeing anything saying it would take under 48 hours. I would expect it to take 2 to 3 business days, based on my experience. I last renewed on a Friday evening, which was after hours. By the following Tuesday (2 business days), my status had been updated. Good luck!!
by qt_ky
Fri Aug 08, 2014 7:42 am
Forum: General
Topic: Purging the XMETA LOGGING_LOGGING table
Replies: 5
Views: 3004

The only time I have seen our XMETA size increase to an extreme is when the debug level logging was enabled within the Info Server Web Console while debugging a PMR and then the original logging level was not restored in a timely manner. Self/Manual XMETA clean up was done which in turn caused more ...
by qt_ky
Thu Aug 07, 2014 10:25 am
Forum: General
Topic: DataStage Designer Connection Issues (81002)
Replies: 7
Views: 2892

Pesky firewalls!
by qt_ky
Thu Aug 07, 2014 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert quote into double quote
Replies: 6
Views: 3544

Did you try using the EReplace function?

Also if you are writing to a text file, then you could use a Sequential File stage in a Server job or Server Shared Container within a Parallel job. It should do the double quote handling you described.