Search found 173 matches

by prasad111
Tue Oct 14, 2008 3:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Embedded Carriage Returns
Replies: 10
Views: 5952

After writting into a file, you can try to execute
dos2unix <file_name>
that should take care of your problem.
by prasad111
Tue Oct 14, 2008 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Embedded Carriage Returns
Replies: 10
Views: 5952

After writting into a file, you can try to execute
dos2unix <file_name>
that should take care of your problem.
by prasad111
Mon Oct 13, 2008 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Characters in Oracle password
Replies: 9
Views: 9196

Just updating.......

Version 7.5 - Need to install patches
Version 8.0 - Need to pass it with escape characters [For example: sea$$wgyc has to be passed as "sea\$\$wgyc" (double quotes has to be present)]
by prasad111
Thu Oct 09, 2008 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2948

How, that is my original question?

I tried to use couple of commands, but not succesfull.
COPY '//PURGE.SETTINGS' TO RT_LOGnnn
WRITE RT_LOGnnn
by prasad111
Thu Oct 09, 2008 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2948

Current project default is to Auto purge the job log up to 5 previous runs.

But when I execute CLEAR.FILE RT_LOGnnn and rerun the job, it keeps on adding the log it is not getting purged (its keep the log for more than 5 previous runs).

Any suggestions is highly appreciated........
by prasad111
Thu Oct 09, 2008 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2948

Current project default is to Auto purge the job log up to 5 previous runs.

But when I execute CLEAR.FILE RT_LOGnnn and rerun the job, it keeps on adding the log it is not getting purged (its keep the log for more than 5 previous runs).
by prasad111
Wed Oct 08, 2008 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2948

We are trying to write a UNIX shell script to automate the cleanup/archive process.........
by prasad111
Wed Oct 08, 2008 6:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2948

Restore purge settings

Hi, I followed the below link for clear.file and restore the purge settings. http://www.dsxchange.com/viewtopic.php?t=92145&highlight=%2F%2Fpurge [code] cd $DSHOME bin/uvsh >COPY FROM RT_LOGnnn........ >CLEAR.FILE RT_LOGnnn >COPY FROM .............. TO RT_LOGnnn [/code] There is a situation wher...
by prasad111
Wed Sep 24, 2008 11:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UV unlock - detail
Replies: 4
Views: 2086

[quote="ray.wurlod"]In 50 minutes only? You are a very fast reader indeed! It's taken me years.[/quote] Before your suggestion, I referred to couple of documents(search in dsxchange)from past one week............. searched for READU... CLEAR LOCK.... and many more in the .pdf files you sug...
by prasad111
Tue Sep 23, 2008 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UV unlock - detail
Replies: 4
Views: 2086

I did go though some of the universe command......it was helpful....

Thanks..
by prasad111
Tue Sep 23, 2008 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UV unlock - detail
Replies: 4
Views: 2086

UV unlock - detail

Hi, From dsxchange search, I was able to understand to unlock the jobs from command prompt. whenever it unlocks a job, it displays >UNLOCK INODE 123456 USER 55555 ALL Clearing Record locks. Clearing GROUP locks. Clearing FILE locks. Please help me in understanding Clearing Record, GROUP(is this rela...
by prasad111
Thu Mar 27, 2008 11:52 am
Forum: General
Topic: Folder stage for writting seq file
Replies: 4
Views: 2158

Thanks for the reply.... I understand the folder stage is working properly......... is there any way before passing to folder stage, I can convert the data to be read to the required output format.... I was searching the forum for solution.......then I clicked on post new topic..........it took me t...
by prasad111
Thu Mar 27, 2008 11:22 am
Forum: General
Topic: Folder stage for writting seq file
Replies: 4
Views: 2158

Folder stage for writting seq file

Hi All, My input file looks like ABC|123|lkjlkj| ABC|453|kljkljluio| ABC|4454|kjhkjhkjh| ABC|334|adaf| DEF|989|jklhkh| DEF|676|khklkh| DEF|343|nnjhj| GHI|234|lhlh| My output files should look like CORRECT EXPECTED OUTPUT file1 - filename ABC ABC|123|lkjlkj| ABC|453|kljkljluio| ABC|4454|kjhkjhkjh| AB...
by prasad111
Fri Jan 25, 2008 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Formatting XML files
Replies: 2
Views: 1084

Select the right repetative group (Select key as yes) in the XML Output stage. For more information refer to XML pdf document chapter 4, it describes how does repetition group works.
by prasad111
Thu Jan 10, 2008 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML output Stage repetition columns
Replies: 2
Views: 1168

As you are using PX, make sure you sort the data based on the NAME column and send it XML output stage, so that it can group it properly.....