DSXchange

I had the compile statement(javac HelloworldApp.java) before in my unix script. I removed it and reran my job. Here is the output. SJ_FRB_NICUA_ETL_TDocsDocuments..JobControl (@Process_TDocsDocuments): Executed: sh /usr/local/data/iadxdata/Temp/Process_TDocsDocuments.sh Reply=0 Output from command =...

Yes, I am using the same ID for both.

Hello Gurus, I am required to call a Java program in datastage. I compiled the java program, and making a call to the program in a unix script. When I execute this script manually in the unix window, it runs fine. When I use the exact same command in the External routine stage, it gives me this erro...

When I pasted the following sql in the before tab to drop constraints, and ran my job, I am getting the following warning: Dynamic_RDBMS_243,0: Warning: PJ_OCC_EVE_ETL_TDctyDocsTypeDB.Dynamic_RDBMS_243: SQLExecDirect: Error executing statement 'SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER ...

Hi, I am using DS 7.5.2 and my job design is as follows. PX job: XMLInput -> transformer -> ODBC enterprise(sql server) I am basically reading data from xml and inserting into the DB. I have a new requirement now to call a stored procedure which drops all the foreign key constraints before loading t...

Yes, I set it to 2147483647(2 GB). Actually, this is the default size I am seeing when I pull my meta data from sql server into transformer. I tried couple of methods: 1. I was able to successfully load a sequential file with the same sql type(Longvarchar 2GB length) and length. 2. I changed the dat...

Hi, I am using a transformer in my job with the following derivation: IF Len(Trim(link_DS_XML.enaa_bank_due_dt))=0 THEN SetNull() else StringToTimestamp(link_DS_XML.enaa_bank_due_dt,'%yyyy-%mm-%dd %hh:%nn:%ss.000') But I am getting this warning when running my job: EnaaEaArticle_Trans,0: Conversion ...

HI Andrew, I tried with $APT_MAX_TRANSPORT_BLOCK_SIZE , but I am still getting the same error. One quick question though. This field is declared as 'image' data type in sql server. When I loaded the meta data in ODBC enterprise, this filed came up as a LongVarBinary with length 2147483647 . I change...

I am getting this error if I try with a smaller size(100000). DocsDocuments_XML,0: Fatal Error: Virtual data set.; output of "DocsDocuments_XML": the record is too big to fit in a block; the length requested is: 201652. The attribute is declared as image in the sql server database though. ...

HI, I am trying to read data from xml into sql server database. Here is my job design: xmlStage -> Transformer -> ODBC enterprise(sql Server) One of the fields happen to be a blob filed. So I declared a LongVarChar with length 2147483647 on both sides of the transformer for this field. When I run my...

I am sorry, I am a little vague with the solution. So if I create a sequence job with a routine, the routine checks if the value of the stage variable and job parameter is same and moves the temp file to new location? Will I be able to access stage variable from parallel job into this routine? I can...

Hi all, I have a parallel job like this: XMLInput -> Xrm -> seqfile. I need to convert xml file data to sequential file. My job already handles this. But I have a new requirement where in I have a job parameter which contains the number the records, and I need to verify the total number of xml recor...

There's no max(a) function in a parallel job transformer. Job param value a1=22. I need to check, after processing the entire xml file, if a=22(meaning number records with mode='d' which inturn equal to the job param) only then I need to write to seq file. If I say, IF a=a1 in the transformer constr...

Okay, I think I'm still not clear in my requirement. I have something like this: Xmlinput -> transformer -> seqfile I have a field called mode in the xml input. In the transformer stage, I defined three stage variables: a,b,c where in a=a+1 if mode = 'd' b=b+1 if mode = 'c' c=c+1 if mode = 'b' so fo...

I think I dint specify my requirement properly. What I need is, each stage variable is incrementing with each record read, and I need to get the maximum of this stage variable, compare it with job parameter, and only if the max(svVar1)=job param, I need to write all the records to a sequential file....