DSXchange

1)Copy_pre_xform: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "INVOICE_CREATION_DATE" to field "INVOICE_CREATION_DATE": No default type conversion from type "string[max=38]" to type "tim...

How do you want the output in Oracle? If you wish to see the data in the output column same as in input the datatype in oracle being varchar, Use TimestampToString(st_dt Timestamp). Let me know if this answers your question. -- JK I have changed the sql types for the Orcale columns to varchar and u...

I am extracting data from Orcale and generating and XML file I am having problem with these four columns from source: INVOICE_CREATION_DATE Varchar DELIVERY_DATE_TIME Varchar INVOICE_QUANTITY Decimal(15) AMOUNT Decimal(13,2) Error messages:------------------------------------------------------------...

My design is

Sqlserverdb----------->Transform--------------->OracleDB

I would like to change the above date columns to load in Orcale . I am working in Parallel not in server .

sample date for the source columns
2007-04-04 00:00:00.000

Thanks,

ray.wurlod wrote:How about wrapping your description in Code tags (edit your original post) so that the column headings and columns are aligned, and we can see what you mean by your design?

Can anyone help me out......................

If you already have a job that parses out the 'detail' records, why not check it after job to see if it found any records to process? Check your 'write' link for a rowcount and, if zero, send the email. You just need a generic "get a link's rowcount" routine (will come in handy in more th...

[quote="ray.wurlod"]Please elaborate on what you mean by "capture". Do you mean "pre-check" in some sense? That would suggest itself as the approach to take. What is the characteristic that makes it bad - nothing in a ...[/quot The business wants to send an email if the...

Case: I have to capture the file if its in this format with just the header information without the detail transaction information. I have to send an email saying the file is bad thats the reason it didnot load anything into the table Document DocVersion="1.0" File="Sales Transactions...

I am trying to insert dates from SQL server to Oracle DB. -------------------------------------------------------------------------------- Column derivations : ------------------------ --------------------------- Source------------------------------------------->target SQL SERVER -------------------...

There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs The routines mentioned above will help you if you are on server edition. If px, the follow Craig's advice. As both the advices are specific to the edition your working on. I t...

DSguru2B wrote:Thats what your doing wrong. CurrentDate() and CurrentTime() will return date and time and not a string. Try something like

Code: Select all

DateToString(CurrentDate()):'T':TimeToString(CurrentTime())

It worked Guru. :D

Thanks to all of them for helping me out to resolve the issue

What exactly is not working :?: I am not able to populate the same format of date in PX. Iwas able to do it in Server using Iconv and Oconv and convert functions 2007-03-20T09:21:22 I changed the sqltype to varchar but still its not populating T inbetween date and time I have used simple way to do ...

DSguru2B wrote:As I suspected, it wont accept T in timestamp. Treat it as varchar.

I did I have changed to varchar and try to use the fuction convert but still its not working in PX

I tried and its working fine in server and now there requirements are changed they would like to test me in PX.

I am not able to fix 'T' inbetween date and time in PX

Thanks,

You use the 'T' for MS-SQL? I've only seen it for XML timestamps. :? We can sit here and guess all day. I prefer to wait for the Shilpa to come back and clarify what exactly is needed. And what the target is. Sorry for not getting back soon :!: My question was I need to populate the timestamp with ...