DSXchange

keshav0307 wrote:can you change the ColumnA_Ref and ColumnB_Ref to ColumnA and ColumnB, that means same name in reference and main link key columns

i did that ..but i got following error
Added field has duplicate identifier(): ColumnA.
as mentioned in my earlier post

Hi I am doing a look up based on 2 columns ColumnA, ColumnB from Primary and ColumnA_Ref and ColumnB_Ref from reference link. The priamary link is coming from the Transformer output and the reference from the Db2 Udb database using the DB2 Enterprise stage. But when i try to run the job it is gettin...

sorry by mistake i included this as a part of the server forum.

here is what i used to get the previous day from the Timestamp

DateFromDaysSince(-1,TimestampToDate(UPDT_TS))

thank you all
naru

hi i have a requirement where in i have to calculate the previous day from the timestamp from the source. I have tried using timestamptodate(TS) - 1, then realised that it is not possible. i have tried using SecondsSinceFromTimestamp, but to no avail. can anyone help me with the right approach. than...

keshav0307 wrote:are you sure you have sufficient previleges?

did you tried inserting records into the table using some other tool ( no idea about db2,but in oracle like sqlplus)

yes i tried inserting it using the common database id.the same id i am using in the db2 Enterprise stage.


thanks,
naren

Hi , When I am trying to connect to db2 Udb on UNIX, I am getting the following error. 05:30:17(000) <DB2_UDB_Enterprise_0> The getpwnam() function failed for the DB2INSTANCE environment variable this is the first time i am trying to connect to this database from my datastage. also i have checked fo...

keshav0307 wrote:what is your target, where do you want to load the extracted data

data will be loaded to DB2UDB database.


Thanks,
Narendar

Hi All, We need to extract the data from OLTP system which is on Mainframe DB2 host We have two approaches to extract the data from DB2 tables: 1. Using DB2 API Stage which directly fetches the data from DB2 tables. 2. Using JCL scripts to fetch the data from Mainframe and ftp the files to UNIX box....

ptallapakam wrote:what is unix command of reset

dsjob -run -mode RESET $Project $JobName

from the Ascential/DataStage/DSEngine/bin/ directory

Requirement: Vertical pivot based on the value of a pivot field (in this case NUM) Data file has two columns - NUM, TYPE (although the solution can be tailored for more) Assumptions: Number of records with the same value in pivot field is unknown Pivot field cannot be an empty string Solution: L1 L...

That's the stage OSH, not the record schemas. Record schemas begin with -record and contain column definitions enclosed in a pair of curly braces. ... The Input Record schema is ( Key:int32 {quote=none}; A:string[max=255]; B:string[max=255]; C:string[max=255]; D:int32 {quote=none}; E:nullable int32...

That's not the record schema. The record schema can be obtained from the generated OSH (in job properties, if enabled) or from the score. ... The generated OSH for the Combine sub records stage is ################################################################# #### STAGE: Combine_Records_72 ## Op...

Please post the record schema from both the input and output links of your Combine Records stage. ... Even i got the same error message when i tried to write the combined record (assuming which is a vector) to seq file. but when i replaced sequential file with a dataset the job ran fine, but when i...

Promote Subrecord stage? I used the promote subrecord and gave col1 as the input ... but I got the error : "main_program: Fatal Error: Not an aggregate field.". My guess is that the promoting of subrecord is already done since my subrecords col1 and col2 are at the top level. Now, what I ...

ray.wurlod wrote:Have you reviewed the capabilities of the Compare stage? ...

Compare stage compares the data from 2 different input links...and my requirement is to compare the data from the same input file.