DSXchange

zulfi123786

lpadrta wrote:I am trying to make the SQL db target integer 10 value 3600000008

check what is the size of integer datatypes on your database and also check if the colum defined is signed or unsigned. even datastage integer cant hold the above value if the column is defined as signed (not unsigned)

zulfi123786

could you share how you have assigned the string in the stage variable ?
what is your source ?

zulfi123786

This one should work

Code: Select all

pxEreplace(AB:"'":CD:"'":E,"'","''",0,0)

zulfi123786

kumar66 wrote:Derivation : pxEreplace(AB'CD'E,"'","''",0,0)

Use a stage variable and set it to "AB'CD'E"
then use the derivation pxEreplace(stage_variable,"'","''",0,0)

zulfi123786

now tell us what is the routine returning ?

zulfi123786

Look up will generate the warning if there are duplicate values over the key columns, in your case there are no duplicates if the microseconds are considered. It is not advisable to look for means of how to suppress warnings rather approach with a resolution to fix the warnings. you have two choices...

zulfi123786

Your Source value is too big to fit in smallint. If you have to store the value then change the data type to integer

zulfi123786

you need to use as shown

Code: Select all

 Iconv(input.Date,"D-YMD")

zulfi123786

synsog wrote:Getting Error:-
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table

As noted this is not error but just a warning and looking at the warning it is clear that on the reference link the column is defined as Timestamp witthout the microseconds extension

zulfi123786

srivalli_b wrote:TDSTAGE -----> XFM---> TDSTAGE

MY SOUCE COLUMN DATATYPE IS VARCHAR
TARGET COLUMN DATATYPE IS BIGINT

use the derivation

Code: Select all

If IsValid("int64",Trim(input.column)) Then Trim(input.column) Else SetNull()

Assuming the invalids should be set to Null.

zulfi123786

Which version of advanced parallel job guide are you referring. I don't recollect having read about dsrecords in version 7.5 however dsrecords is documented in orchestrate users guide

zulfi123786

PhilHibbs wrote:Just as I hit "Submit", a solution occurred to me - have a look in the PXEngine/bin directory and see if anything rings a bell! The answer is: dsrecords.

to be more specific:

Code: Select all

dsrecords -n

as documented in the Ochestrate guide

zulfi123786

this is done in server using Ereplace function.
Some one here has posted a parallel version of it. you could use it to fit your purpose

zulfi123786

2)Should i need to use schemafile for target sequential file If your sequential file is the origination stage of data in your job then you need to specify schema file to enable RCP, in your case its not. More over, RCP will not be of much help based on your inputs where you have only a Oracle stage...

zulfi123786

Gurus, could some one Please share any thoughts ?

DSXchange

Search found 726 matches

Re: Convert Char 10 to Integer 10 gives unexpected results

Re: Lookup Fails on Timestamp with MicorSeconds.

Re: Lookup Fails on Timestamp with MicorSeconds.

Re: VARCHAR TO BIGINT

Re: Data Set record count (not orchadmin)

Re: RCP Clarification