DSXchange

Hi, We have migrated the project from DS V6.0 to V7.5.1a server edition. when testing the jobs in new version i got one issue. When I ran the job I am getting the warning message like: STGDiscountsODSLoadActTypeUANZ..Transform: ORA-01400: cannot insert NULL into ("ODS"."ACTIVITY_TYPE&...

Hi Craig, Thanks for your reply. Actually I need to include some conditions in the WHERE cluase, for tht I need custom sql. My actual query looks like. SELECT DISTINCT A.PRODUCT_ID, A.PROD_COMP_NBR, A.UOM_STOCKING, NVL(A.SU_CONV_FACTOR,0), B.AZ_PRODUCT_ID FROM ODS.PRODUCT_SKU_DETAILS A, ODS.PRODUCT_...

Hi All, First of all Thanks for you help. I am still facing the same problem. I am facing it with only custon SQL in Look up Oracle stage. If it is generated SQL, the job is running fine. I took the qurey from Generated SQL and put it in custom sql as it is and tried to vew the data, but in this cas...

Hi, We are migrating our project from version 6.0 to 7.5.1a in Tru64 OS. I am having Oracle stage as lookup and its having where condition. The custion SQL Stagement is ike: SELECT TESTING_TB.PRODUCT_ID, TESTING_TB.PRO_COMP_NBR, TESTING_TB.UOM_STOCKING, TESTING_TB.SU_CONV_FACTOR, TESTING_TB.AZ_PRODU...

Hi, I got some more information in Log i.e. JS_XXX..JobControl (@Execute_Del_DS): Executed: sh -x cd /home/dsadm/monthly_churn/cs8_basedump_rem.sh Reply=1 Output from command ====> + + /usr/bin/basename cd command=cd + [ cd = type ] + [ cd = hash ] + cd /home/dsadm/abc/cs8_basedump_rem.sh cd[53]: /h...

Hi, I have a Sequence S1 which has J1, J2, J3, J4 jobs. J3 is my Execute Command activity which will run script. Now my Job Seuence S1 got aborted and the error log is 16:05:22: Execute_Del_DS (COMMAND sh -x) started 16:05:22: Execute_Del_DS finished, reply=1 16:05:22: Stop_Run Executed 16:05:22: Se...

Hi,

I am new DataStage PX. When I ran the jobs through Job Sequence, one job got aborted and it gave Fatal error like

main_program: ORCHESTRATE step execution terminating due to SIGINT

What could be the error. Please help me to solve this issue.

Thanks in Advance.

Hi,

I want to import a jobs from Server 7.5.1.A to Server 7.5x2, when I try to import one category its giving error like

XYZ.dsx can only be imported when the client code page is 874-it is currently 1252.

What does it mean? please help me to resolve this issue.

Thanks in advance

Hi,

I want to import a jobs from Server 7.5.1.A to Server 7.5x2, when I try to import one category its giving error like

XYZ.dsx can only be imported when the client code page is 874-it is currently 1252.

What does it mean? please help me to resolve this issue.

Thanks in advance

Hi ArndW, Thanks for your help. Now I amgetting the data into output file. But one question.. 1) Now how shoud I get the data into my actual columns(6 columns) from this one column? 2) My source file is comma seperated, Some of the records have commas with in the values, how shoud I handle those com...

Hi Arndw, I tried as you suggested, like I took single column as Dummy n delimiter and Quote character taken as "000" and Ereplace function in Transformer stage and sent output as single columun. But when I run this job, getting the error like Test_Quotes..Transformer_0: |Test_Quotes..BAL_...

Hi Arndw, I tried as you suggested, like I took single column as Dummy n delimiter and Quote character taken as "000" and Ereplace function in Transformer stage and sent output as single columun. But when I run this job, getting the error like Test_Quotes..Transformer_0: |Test_Quotes..BAL_...

Hi Arndw, I tried as you suggested, like I took single column as Dummy n delimiter and Quote character taken as "000" and Ereplace function in Transformer stage and sent output as single columun. But when I run this job, getting the error like Test_Quotes..Transformer_0: |Test_Quotes..BAL_...

Hi ArndW, Thanks for your reply. The source of line is "TOUCH \"N\" TALK" . Ray, As per your Suggestion, I used 000 in quote character and used Trim function but some of the values in the source have comma(,) with in the value itself and as my file comma seperated, its giving som...

Hi, I have a column which contain varchar value and is double quoted. But with in the value again I have double quote character, when I run the job its getting aborted due to this another quote. I searched for help in the search and found functions like Ereplace(source.Field001, ' " ' , ' ' ) E...