DSXchange

hi guyz,
having a bit of issue achieving the following
source:
1
1
1
2
2
3
3
3

how to get the following
1 1
1 2
1 3
2 1
2 2
3 1
3 2
3 3

is there any built in function in ds that can achieve that. i tried my best, couldnt find any.

Troy,
I think you just said it. Try that. It should work. Read the data using xml input, use the xml transformer, use sequential stage as ur passive stage, into the transformer, change the format to ebcidic and into cobol copy book.

I will do that. Thanks once again.

Guyz, The problem lied in metadata mismatch. Thanks for your help Kcbland. You sure directed me in the right direction. From the sql server, the key was set to bigint. when i changed that to integer within datastage, the job executed fine. The target table still has bigint, but it executed fine. Now...

Guyz, The problem lied in metadata mismatch. Thanks for your help Kcbland. You sure directed me in the right direction. From the sql server, the key was set to bigint. when i changed that to integer within datastage, the job executed fine. The target table still has bigint, but it executed fine. Now...

hey,
guess what i found....
when i use the updte action as "Delete existing rows only". the job executes successfully. but any other update action forces the job to abort horribly.
why is that?

okay!!!
well thanks for your time though. I guess i have to talk to my dba about it.

i agree, i do not have the permission to truncate the table, thats why its giving me an error on that before it can even go towards the insert command. If the problem lies in datatype mismatch, then why is it working fine with odbc stage??? thats whats puzzling me. doesnt the word "BIND" r...

i am using insert without clearing.....when i use TRUNCATE and then INSERT option , it gives me the following error drstst..Dynamic_RDBMS_6: [DataDirect][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this operation on table 'CGI_IDB.Prdcr_Cmp.STG_POLICY'. pretty weird h...

sure, the sql generated in the source is SELECT POL_ID,POL_INSTNC_ID,CRETD_OPER_ID,TO_CHAR(CRETD_DT, 'YYYY-MM-DD HH24:MI:SS'),SOAR_OPPOR_DOC_ID,EST_INSRD_LIVES_NUM,TO_CHAR(POL_LAST_RENL_DT, 'YYYY-MM-DD HH24:MI:SS'),TO_CHAR(POL_NEXT_RENL_DT, 'YYYY-MM-DD HH24:MI:SS'),PH_LEGAL_NM,POL_DESC_TXT,TO_CHAR(P...

i am using generatel sql. if there is any kind of metadata mismatch. wont loading both the source and target drs with a particular table solve it. i even tried that. is this really ds or sql server problem???

Hi Ray, I tried to put odbc in drs, both source and target. still giving me the same error. I tried deleting the meta data and importing it again. still the same error. actually my dba built the staging tables as mirror images of the target tables. i am running a test job as target table ---->xfm---...

Hey Bala,
I dont think its the metadata issue. I tried to build another job, a straight load between two drs stages. Its still aborting with the fatal message pointing towards the target DRS stage.

Hi guys, I am encountering a small issue with inserting records into sql server using the DRS stage. Its working fine with the ODBC stage as my target stage but i hate that stage, totally kills the performance. When i use DRS stage as my target, it gives me the following error message and aborts. wa...

Hi,
Try using Db2 Enterprise stage instead of Db2 bulk load stage. I have been through this problem and for some reason the Db2 EE stage worked fine with the load option.