DSXchange

Hi,

Any one can suggest me
how to pass single input file unique and duplicate records seperately in different outputs without usage of transformer stage.

Hi, Please any one help me, Why this problem arising, What i have to do for the problem solvation. APT_CombinedOperatorController(2),0: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record dropped.

Hi,

I am getting below warning , and records are dropping.
Can any one tell me, in which senarios records will drop and what are the solvations for it

Field Decimal(13,3)

APT_CombinedOperatorController(3),0: Field 'field' from input dataset '0' is NULL. Record dropped.

Hi, I have extracting the data from two table Table1 Table2 Name Score Name Score A 1 C 3 B 2 D 4 Now when i funned this data i need the data like C 3 D 4 A 1 B 2 Please any one can helpout how it do.

Hi friends,

Can any one share how to implement sparse lookup

When i use this TimestampToString(LNK_CONV_TRANS2.SERVICE,"%yyyy-%mm-%dd") in Trnsformer showing below warning APT_CombinedOperatorController(0),0: Data string '2009-11-01' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the data string has fewer characters than expected. '19971001' is ...

it's not working

gssr wrote:Which function are you using..?
Try this TimestampToString(DATA,[%yyyy-%mm-%dd])

from TimestampToString

ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...

showing same message

gssr wrote:Remove the %hh%mm%ss and try to execute

Hi Friends, While changing from timespamp to string i am getting below warning and data showing null, i tried some ways but again and agin showing the same warning, can any one help in this solution. APT_CombinedOperatorController(0),0: Data string '19971001' does not match format '%yyyy-%mm-%dd %hh...

here taking means, while loading the fields in odbc, timestamp field instead of timestamp showing the binary datatype.

ray.wurlod wrote:I still don't understand your meaning of "taking". Can you try to express this in different words? ...

In sequel server datatype is Timestamp, but when i load the in datastage odbc stage its taking binary(8). my source and target is timestamp Datastage taking as binary( 8 ) What precisely do you mean by this? What data type is reported when you import the table definition using the orchdbutil facilit...

thanx for your help and with the " [ ] " brackets my problem has solved

chulett wrote:ODBC doesn't support them, from what I recall. For Access you'd need to put square brackets around them, perhaps the same would work here? ...

I tried with single quote its giving below error.

[IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 102: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Key'.

SELECT `A`.`A Key` AS A_Key, `A`.`E Key` AS E_Key, `A`.ID FROM dbo.`A` I am trying above query in ODBC connector but its giving bellow error, please can clarify any one [IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 102: Msg = [IBM (DataDirect OEM)][ODBC SQL...