DSXchange

consulting wrote:Thanks
In server we can use substring. How about in Px?

you can use substring in PX too.
Regards,

Restart the production server? Are you working in 1 employee only company? BillB, You need to go your ../DataStage/PXEngine.751/java directory to re-start the jobmoninit by issuing the follwong command: sh jobmoninit start $APT_ORCHHOME Sorry for the earlier reply My Intention was to restart the jo...

If you can do this in UNIX or Oracle (Oracle supports regular expression), pattern matching may help. Or you could call shell commands in your job somehow, e.g. echo yourfield | grep -c -e "word1|word2..." Or you could write a parallel routine to achieve this. Hi ArndW, I think this is no...

As a temporary work around disabled APT_NO_JOBMON from administrator, but still looking for resolution Cheers Restarted the production server? If it goes then no problem I think its a temporary problem. restart the server. if it comes again then reply with the following settings APT_NO_JOBMON APT_M...

Hi Can any one help me about configuring the oracle database which multiple source tables to be accessed in datastage. Please help me here Regards Rajesh How you want to fetch records from multiple tables. Do you want to know how to increase the maximum number of threads alllowed in oracle database...

Hi Gang ... I have a PX job with 3 Lookups - the reference file for each is a DataSet. Are there performance gains to be relized by combining these 3 Lookups into one Stage? ... or will the Optimizer do that for me? thanks ... ... tom why dont you try both the options and let us know what the resul...

skp wrote:Hi all,


How can I get the log of a job from the director into a text file.
I need it urgently can anyone help me out.

Thanks in advance.

why don't you use print to file option.

Welcome aboard. Load the max date into a Lookup File Set with Entire partitioning. This has a constant (say "X") as its key, and the max date as a non-key field. Use a Lookup stage to lookup the re ... I just signed up for Premium Content how do i view the response? once you get your prem...

Hi I want to do null handling using Modify stage rather than transformer stage.I am using following function. DEF= Handle_Null (DEF,'AAAA') DEF is the column name. But rather than transferring null as AAAA, it is transferring null only. Can you please give me some solution? go to learning center an...

one more thing

I tried running that job alone it runs fine

but again i tried with the sequence it failed with same error

don't know why its happening

Regards.

Sounds like you need to get your Oracle DBA on board, and maybe your network administrator as well, to find out whether it's Oracle that's raising the SIGPIPE signals and, if so, for what reason . I went through the file OshExecuter.sh but i cannot find any thing unusual i am posting that script, m...

you can use this command its there in 8x but dont know its there in 7x or not cd path of dscmdexport.exe dscmdexport /D=ServerIP:9080 /H=ServerIP:31801 /U=UserName /P=password ServerName/ProjectName ProjectExport.dsx you can put it in a batch file and then schedule it if you want only few jobs from ...

This is some new meaning of "superior", then? :lol: Do you know what this port number is used for? Ans 1: I meant the configuration his higher(almost double) than the older one. Yeah, haven't encountered anything better except the timings. :? Ans 2: port 13400 is used by oracle applicatio...

additionally this problem started when we moved our code to a superior server.

In older server the occurance of this error was very less.

There should be more to the error message (something with segmentation fault). Can you post that? Also, if you reset the job do you get an entry in your log with "from previous run"? ... I am getting 1 warning some times but not all the times main_program: Received SIGPIPE signal caused b...