DSXchange

chulett wrote: My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like. ...

I got month as MON from dual. but when i have inserted this date into the table there am getting as 22-aug-2008.

can i have this as 22-AUG-2008

Thanks,
Deepak

chulett wrote:

Code: Select all

select to_char(sysdate,'DD-MON-YYYY') from dual

...

Thanks Chulett.

I got the required format but now i have DD-mon-YYYY.
can i get the output as DD-MON-YYYY

Hi All, My input is sysdate from dual table(i am using ORACLE enterprise stage). next stage i have a transformer where i am passing some hardcoded message and concatinating this date(sysdate) to one stored procedure stage, which will pass the above message to some table. The message should appear as...

keshav0307 wrote:if it is working fine then correct option only :D

Thanks Keshav

keshav0307 wrote:use head stage and number of records 1.

Hi Keshav,

Thanks for your suggestion.
i have used options,
Allow all rows = FALSE
No Of Rows/Partition = 1

All Partitions = FALSE
No Of Partitions = 1

and it is working fine. Can you confirm are these options.

Thanks,
Deepak

chulett wrote:Constraint?

Code: Select all

@OUTROWNUM = 1

...

Hi Chulett,

I have tried @OUTROWNUM = 1 option, this time 2 header records are written to sequential file. But i need only 1 record.

thanks,
Deepak

Hi All, My reqirement is to generate ASCII txt files from a table. The file should have 2 headers in it. I have 3 o/p links from a transformer to 3 Seq file stage. one for each header and the last one for actual data. All headers are hardcoded(except one where am using a date from parameter), not co...

Did you not get them because you didn't search for them or did you not "get" them meaning that you did not understand them? The easiest solution, where the job is run monthly (presumably on the las ... Hi ray, Thanks for your suggestion. The job is running on 8th business day of the month...

Hi All, This topic might have been discussed previously, but i didn't get them. please have a look and provide your suggestion. My requirement is to create text flle from a table and output text file name should be xyz_yyyymmdd.txt where yyyymmdd is the last day of the previous month. the job is a m...

Hi All,

Thanks for your valueable suggestions.
I got it. it has been resolved.

thanks,
deepak

Hi Rich, Thanks for your suggestion.... now the job is aborting using lookup stage if lookup fails. now i have to reject these records or file which fails lookup. am getting error message like this. "Reject link is not allowed unless an input reference link failure property is set to reject&quo...

Hi,

Thanks for your suggestions.....
Is there any way to abort a job after join produces zero records.

Thanks,
Deepak

Hi All, I have a job, where calendar_dt from source file should match the calendar_dt from a file, which is created by querying a table. i just wanted to know if the join condition fails, does the job fails too? in my case, the job is not failing and clearly data is getting loaded as it should be. I...

yes, some solutions include server may be busy. but could you please let me know about the log message from the job which has message like : Item #: 1 Event ID: 0 Timestamp: 2007-10-31 16:10:01 Type: Fatal User Name: dsadm Message: Job IBTLoan_Update_Chkpnt_Complete_Job cannot be multiply invoked It...

Hi,

Its running quite fine in Dev but am getting this error only in UAT environment, which i can see only logs.

thanks,
Deepak