DSXchange

HI, I have a job which runs without any problem for few runs then it aborted with no warnings and a fatal error "job failed because of previous errors". there are no warnings nor fatal errors before. when the job runs it runs for 3-4 minutes but now when it aborts it aborts in 6seconds fro...

I am facing with the same problem of not able to override the values in parameter set from a sequence job. Can somebody help me with this. Can you provide me with the patch numberif its a bug. Thanks I have a developer that reported the following issue: Parallel job utilizes a parameter set comprise...

I am facing with the same problem of not able to override the values in parameter set. Can somebody help me with this. Can you provide me with the patch numberif its a bug. Thanks I have a developer that reported the following issue: Parallel job utilizes a parameter set comprised of regular job par...

Hi
I was trying to do a full outer join using merge stage (server edition) , but I dont see any option that says full outer join .I tried the complete set option but it just behaved like an inner join .

How can we get full outer join with merge stage ,

Thank you

Hi , the following are the logs i am getting when trying to run a job whose source is .DAT file Sequential_File_0,0: Import consumed only 286bytes of the record's 287 bytes (no further warnings will be generated from this partition) Sequential_File_0,0: Import warning at record 0. Please help me out...

bgs_vb, Write a small shell script continously sweeping the folder for the file with the given specific pattern, if the file is present you can trigger the sequence. In korn shell use if [[ -f *pattern ]]. You dont need Start Loop and End Loop stages, just a while loop that runs for a specific time ...

Hi, I would like to congratulate and thank DSXchange for the success of the EE trasition lab in Dallas. The class material was well constructed and effectively delivered by none other than Ray Wurlod. The hands on approach was very good. It was was nice to see all the DSXchange folks that make this ...

DataStage has the PeopleSoft EPM pack, which includes all the jobs, Sequences and Metadata for loading the Data into the EPM Warehouse.

koojo wrote:Can DS read and write to a peopelsoft database? If yes does it need a extra pack?

Ah ! I forgot to mention the lower end (1 to 31) !

dsrules

yeah we can. I was thinking more of a generic solution for such EBCDIC ASCII, non printable characters problems, like

How about checking for high end bit is true then we strip the character to null, what would be the repercussions !

Thanks Ray. I will try the Convert(Char(13), "", InLink.TheString) tomorrow. Also what do you feel about the code I posted , we can modify it to strip all the non printable chars to nulls rather than space, but the CR was also being stripped off and we were getting concatenated words. It w...

All the options have been tried, DOS, UNIX. Using 'column contains embedded terminators' takes care of the problem of reading it, but the removal of ^M has to be done. The code which was posted basically strips all the non printable chars to '.', before doing that I am converting any valid '.' to a ...

Kumar,
Why not handle this by a before job subroutine which executes Unix cmds which strip the Header and Trailer in a shell script. Then have the CFF metadata for the Data records

HTH

dsrules

Hi, We are trying to load data from a DB2 table after some transformations. The problem we are facing is the data when exported from the DB2 table to the unix box using the DB2 export utility is 2,"Failure to submit Audited ^M Financials with report of ^M Internal Controls" 3,"Failure...

Thanks a lot Ray ! Will try it.

dsrules